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.

3.

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...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.