OraFAQ Forum: Data Guard » Temporary tablespace is empty

Home » Server Options » Data Guard » Temporary tablespace is empty

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Temporary tablespace is empty [message #239591]

Tue, 22 May 2007 13:10

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

I tried a 'show parameters' on my physical standby database after opening it in "READ ONLY" mode, and got the following error:

SQL> recover managed standby database cancel;
Media recovery complete.
SQL> alter database open read only;

Database altered.

SQL> show parameters
ORA-25153: Temporary Tablespace is Empty

My first reaction is "so what if the temporary tablespace is empty?" but I really want to see the parameters on this database.

Report message to a moderator

Re: Temporary tablespace is empty [message #239592 is a reply to message #239591]

Tue, 22 May 2007 13:13

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

ORA-25153: Temporary Tablespace is Empty
Cause: An attempt was made to use space in a temporary tablespace with no files.
Action: Add files to the tablespace using ADD TEMPFILE command.

Report message to a moderator