This content has been marked as final. Show 3 replies
What does the inability of a temp segment to extend have to do with "Database Security - General"?
Please lock this thread and open one in the correct, "Database General" forum.
When you do include all of the important, relevant information you did not provide here such as:
1. Version number
2. What you are importing and how (IMP, DataPump, something else?)
3. Size and available space in the temp tablespace and is it set to autoextend?
4. Available disk space for temp to autoextend?
5. Extract from the alert log showing messages corresponding with the issue.
It's nothing to do with the temp tablespace. The 'temp' message just means its a temporary segment until the creation of the object is complete as opposed to sort space etc.
You just need to add more data files to the AXPERT tablespace and the job will pick up and continue unless the resemble timeout is passed. If it has you'll need to restart that object or even the job itself.