ORA-25153: Temporary Tablespace is Empty

ORA-25153: Temporary Tablespace is Empty

During the Full backup of database through exp will give the following error:

exp file=E:\fullbackup.dmp log=E:\fullbackup.log full=y

EXP-00056: ORACLE error 25153 encountered
ORA-25153: Temporary Tablespace is Empty
EXP-00056: ORACLE error 25153 encountered
ORA-25153: Temporary Tablespace is Empty
EXP-00000: Export terminated unsuccessfully

Issue
As per error, its seems to belong with TEMPORARY Tablespace.

Solution
On check the temporary tablespace is not empty, Not having Temp file as shown below:

SQL> Select file_name from dba_temp_files;
no rows selected

Fixed it by adding a TEMP file to the temporary tablespace.

1. Check the temp tablespace name present in Database:

SQL> select name from v$tablespace;
NAME
------------------------------
SYSTEM
UNDOTBS1
TEMP

2. Check the location of all existing data file.

SQL> select file_name from dba_data_files;
FILE_NAME
-------------------------------------------------
D:\ORACLEXE\ORADATA\XE\UNDOTBS1.DBF
D:\ORACLEXE\ORADATA\XE\SYSTEM.DBF

3. Add temp file in the TEMP tablespace.

SQL> alter tablespace temp add tempfile 'D:\ORACLEXE\ORADATA\XE\TEMP01.DBF' size 1G reuse;
Tablespace altered.

4. It will fixed the issue.

Leave a Reply