DB13 Error ORA-25153: Temporary Tablespace is Empty

If your DB13 actions finished with  “ORA-25153: Temporary Tablespace is Empty” error message then you should check your database TEMP tablespace first…

Let’s check an example about the issue ;

DB13 actions finished with error like below

DB13 Error ORA-25153: Temporary Tablespace is Empty

Click one of it to get more info

DB13 Error ORA-25153: Temporary Tablespace is Empty

Check the detail log

DB13 Error ORA-25153: Temporary Tablespace is Empty

ORA-25153: Temporary Tablespace is Empty
ORA-06512: at “SYS.GET_STATS_EXTENSION”, line 12

Go to DB02 and check the TEMP tablespace status (PSAPTEMP)

For our situation it looks like no temp datafile assigned to the system

DB13 Error ORA-25153: Temporary Tablespace is Empty

Add Tempfile or Create new tablespace

Add new Tempfile ;

ALTER TABLESPACE PSAPTEMP
ADD TEMPFILE ‘O:\ORACLE\SID\SAPDATA5\TEMP_1\TEMP.DATA1′ SIZE 2G
 REUSE AUTOEXTEND ON NEXT 100M  MAXSIZE 10G;

Create new Temporary Tablespace ;

CREATE TEMPORARY TABLESPACE PSAPTEMP TEMPFILE
 ‘O:\ORACLE\SID\SAPDATA5\TEMP_1\TEMP.DATA1′ SIZE 3G AUTOEXTEND ON
NEXT 100M MAXSIZE 10G;

Now we can check the DB02 again and we should get a screen like below ;

DB13 Error ORA-25153: Temporary Tablespace is Empty

Now we can try again DB13 actions and i hope also your actions will be completed successfull like below…

DB13 Error ORA-25153: Temporary Tablespace is Empty

 

Leave a Reply


× 6 = forty two

Blogroll