CODEWITHSUNDEEP
sqloracle-database
ReiRei
ReiRei

Reputation: 83

SQL Temp Tablespace is Empty

Does anyone know why I'm getting this error?

ORA-25153: Temporary Tablespace is Empty

I'm doing a simple SELECT OWNER FROM DBA_TABLES; query and it displays the data properly but when I try to narrow the OWNER columns down then it gives me this error.

SELECT OWNER 
  FROM DBA_TABLES
 WHERE OWNER = 'NAME';

Upvotes: 2

Views: 14781

Answers (1)

Dor Cohen
Dor Cohen

Reputation: 17080

your problem is described perfectly at the following post, but if you don't have DBA rights or knowledge you won't succeed to overcome this error and I strongly suggest you to approach your DBA.

http://www.mydigitallife.info/ora-25153-temporary-tablespace-is-empty-error-in-oracle/

The cause for the ORA-25153 error is because attempt was made to use space in a temporary tablespace with no files (no datafiles defined).

To solve the problem, the solution is just by adding files (datafiles) to the TEMP tablespace by using ADD TEMPFILE command, or by using “Add Datafiles” in Oracle Enterprise Manager.

Upvotes: 2

Related Questions