Hi All
im having a problem with a temporary tablespace. Basically, while i am using a user level export, i get an error:
ORA-01652: unable to extend temp segment by xxx in tablespace xxxxxxxxxxxxx
i am using oracle 9i version Release 2 (9.2.0.1.0) for Windows
I have tried the following:
SQL> Shutdown Immediate
and
SQL> Startup
But the export still fails. It is my understanding that the temp tablespace filling up is normal as it keeps forming extents, but once the db is shutdown, it should clear the extents! This doesnt seem to happen.
Currently, the temp tablespace has auto extended itself to 20gb in size!!!!!!!! it was 10mb!
plz let me know your thoughts!
Cheers~~
im having a problem with a temporary tablespace. Basically, while i am using a user level export, i get an error:
ORA-01652: unable to extend temp segment by xxx in tablespace xxxxxxxxxxxxx
i am using oracle 9i version Release 2 (9.2.0.1.0) for Windows
I have tried the following:
SQL> Shutdown Immediate
and
SQL> Startup
But the export still fails. It is my understanding that the temp tablespace filling up is normal as it keeps forming extents, but once the db is shutdown, it should clear the extents! This doesnt seem to happen.
Currently, the temp tablespace has auto extended itself to 20gb in size!!!!!!!! it was 10mb!
plz let me know your thoughts!
Cheers~~
