My Oracle Support Banner

ORA-25153 Reported when Adding a Temp File to the Temporary Tablespace (Doc ID 1384299.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 and later
Information in this document applies to any platform.

Symptoms

When attempting to add a temp file to the temp tablespace,error reported:

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/dev/rdata_temp01'SIZE 1000M REUSE AUTOEXTEND OFF;
ORA-00604: error occurred at recursive SQL level 1
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at line 12



The temporary tablespace does exist but has indeed no temp files as shown below:

SQL> select tablespace_name,status from dba_tablespaces where contents='TEMPORARY';

TABLESPACE_NAME                STATUS
------------------------------ ---------
TEMP                           ONLINE

SQL> select file_name, file_id, tablespace_name from dba_temp_files;

no rows selected

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.