Skip to content

Archive for

ora-25153 temporary tablespace empty

When i going to start the export of a one user, it shows error ,

ora-25153 temporary tablespace empty.

Solution :

Add one temp file for temporary tablespace

sql>alter tablespace temp add datafile ‘D:\oracle\product\10.2.0\oradata\orcl\temp02.dbf’ size 10m;

Tablespace altered.

Now i can able to start export.

view: dba_temp_files