Skip to Content
1
Former Member
Jul 07, 2009 at 12:32 AM

PSAPTEMP tablespace

1708 Views

HI all,

I am trying to run an Import of the client and its getting stuck, so before running the import i started the Database Optimizer Statistics and when i checked the system log i was getting ORA-25153: Temporary Tablespace is Empty and then i checked DB02 and saw PSAPTEMP did not have any space allocated ,as i have restored this system and created a new Control file , so in the process the PSAPTEMP tablespace has affected.

PSAPTEMP 0,00 0,00 0 NO 0,00 0,00 0 0 0 0 ONLINE TEMPORARY

Can someone please help me resolve this issue.

Thanks