Blog

In our daily DBA tasks, you may encounter the ORA-25153 error. Today we will discuss the same in detail how to resolve this error.

Problem :

ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_LOB", line 724
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4546
ORA-06512: at line 1

Solution :

Step 1 : Check if any temporary tablespace exists.

SQL> select * from v$temp_space_header;

no rows selected

Step 2: Create temporary tablespace issuing below command :

SQL> create temporary tablespace TEMP  tempfile '/oradata/TEST/temp01.dbf' size 2G;
create temporary tablespace TEMP  tempfile '/oradata/TEST/temp01.dbf' size 2G
*
ERROR at line 1:
ORA-01543: tablespace 'TEMP' already exists

Step 3: If still getting errors, create a Temporary tablespace with a different name, you will succeed

SQL> create temporary tablespace TEMP1 tempfile '/oradata/TEST/temp01.dbf' size 2G;

Tablespace created.

Step 4: If you want, make it the default temporary tablespace :

SQL> alter database default temporary tablespace TEMP1;

Database altered.

So here are the detailed steps with which you can resolve the ORA-25153 error very easily. Hope that helps!!

Also, you can get the reference from the below Oracle Doc ID too.

ORA-25153 Temporary Tablespace Is Empty (Doc ID 422723.1)

Our Other ORA Error-Related Articles :

• ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
• ORA-03113 Error: end-of-file on communication channel