Home » Server Options » Data Guard » Run an EXPORT against a standby database. (Oracle9i; Unix.)
Run an EXPORT against a standby database. [message #287594] Wed, 12 December 2007 18:56 Go to next message
Messages: 59
Registered: March 2005
I am trying to run an export against a STANDY BY DATABASE.

The steps i have already taken are,
I opened the standy in a READONLY

Then when i run my export, it gives me an error saying giving me an error saying,

EXP-00008: ORACLE error 25153 encountered
ORA-25153: Temporary Tablespace is Empty
EXP-00000: Export terminated unsuccessfully

what is the work around this? I have never worked with standby databases until today.

I cannot create a temporary tablespace because the database in an read only mode.

What are my options here?

Thank you!
Re: Run an EXPORT against a standby database. [message #287598 is a reply to message #287594] Wed, 12 December 2007 20:29 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
Have you actually tried to add a tempfile once in read only mode?

You could try to increase the size of your sort_area_size or use direct=n.
Previous Topic: Is Data Guard running except transfer TEMP Tablespace?
Next Topic: importance of standby_archive_dest in dataguard/Real time log application in Oracle9i
Goto Forum:

Current Time: Wed Aug 10 05:56:12 CDT 2022