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.