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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.