While export if you are getting below :

. exporting rollback segment definitions . exporting database links . exporting sequence numbers . exporting directory aliases . exporting context namespaces . exporting foreign function library names . exporting

PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions . exporting system procedural objects and actions

EXP-00008: ORACLE error 25153 encountered

ORA-25153: Temporary Tablespace is Empty

ORA-06512: at “SYS.DBMS_LOB”, line 443

ORA-06512: at “SYS.DBMS_SCHED_MAIN_EXPORT”, line 580


ORA-06512: at line 1


SQL> select distinct TEMPORARY_TABLESPACE from dba_users;



SQL> select file_name from dba_temp_files where tablespace_name='TEMP2';

no rows selected

We can see the the temporary tablespace (TEMP2) is assigned to the users, but in real it doesn’t contain any temp file. i.e it is empty.

So we need to add tempfile to TEMP2 tablespace.

SQL> alter tablespace TEMP2 ADD TEMPFILE '/uv1145/data/oranetwork/temp_temp01.dbf' size 200m;

 Tablespace altered.

Now do the export, it will work fine.