DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Thursday, September 29, 2016

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;

1 comment:

Sridevi K said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.