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


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.

Now do the export, it will work fine.