Database Administration (MOSC)

MOSC Banner

Couldn't create temprary datafiles

edited Aug 21, 2012 8:17PM in Database Administration (MOSC) 17 commentsAnswered ✓
I clonded a database, and trying to add datafile for the tempoary tablespace as the last step and I keep getting the following error message.

ALTER TABLESPACE TEMP1 ADD TEMPFILE '/u02/QA/db/apps_st/data/temp01.dbf' SIZE 3000M REUSE AUTOEXTEND OFF;

ORA-00604: error occurred at recursive SQL level 1
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.NAME_SECURITY", line 166
ORA-06512: at line 2

I did find the following warning message in alert log. Are they related?

WARNING:Oracle instance running on a system with low open file descriptor
        limit. Tune your system to increase this limit to avoid

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center