SOLVED

ORA-25153: Temporary Tablespace Is Empty While Doing Export

Asked by OracleDba••11 views•oracle
1
2
3
4
5
6
7
8
9
10
11
12
13
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
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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 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.

Hope it Helps !
OracleDba•

Post Your Solution