ORA-25153 Reported when Adding a Temp File to the Temporary Tablespace

(Doc ID 1384299.1)

Last updated on JUNE 30, 2016

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms