- 08 Dec, 2023
- 0 Comments
- 40 Secs Read
ORA-25153: Temporary Tablespace Is Empty While Doing Export
Problem :
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 “SYS.DBMS_SCHED_WINDOW_EXPORT”, line 14 ORA-06512: at line 1
Solution :
SQL> select distinct TEMPORARY_TABLESPACE from dba_users; TEMPORARY_TABLESPACE ------------------------------ TEMP2 SQL> select file_name from dba_temp_files where tablespace_name='TEMP2'; no rows selectedWe 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.