ORA-25153 temporary tablespace is empty

ORA-25153 temporary tablespace is empty

Solution: Use one of the below to fix the issue.

1. Create new datafile for defaul TEMP tablespace or solution 2

SQL> alter tablespace temp add tempfile ‘xxx/temp.dbf’ size 500M;

Tablespace altered.

2.Make existing TEMP1 tablesapcle to defaul temporary tablespace

SQL> alter database default temporary tablespace temp1;

Database altered.

SQL> drop tablespace temp including contents and datafiles;

SQL> create temporary tablespace temp tempfile ‘xxx/temp01.dbf’ size 100m autoextend off extent management local uniform size 1m;

SQL> alter database default temporary tablespace temp;

4. Issue exists only for particular use then

SQL> alter user sys temporary tablespace temp1;

Doyensys

A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter.