Re: Exporting from a "standby" database

An Oracle version would help!

If you are using 8.1.5, and your database is genuinely open in read only mode (as opposed to being a standby database in special recovery mount mode), then if your temporary tablespaces are created using locally managed tablespacem and with the 'tempfile' keyword, instead of the 'old' datafile keyword, then sorts can indeed take place (ie, writes to temporary tablespace) despite the database being read only.

I don't know for sure that this will let Export do its stuff, but since the error message suggests that writes to TEMP are the issue, you can only give it a go and keep your fingers crossed.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



<alanolya_at_my-deja.com> wrote in message news:8pjb0r$2u4$1_at_nnrp1.deja.com...


> Hello,

>

> Is there a way to "export" a "standby" database which is in "read-only"

> mode? I get Oracle Error 1682 ("read only DB cannot allocate temporary

> space"). Why should an export, which after all is nothing but a long

> read of the datafiles, need to write to some space? Is there any way

> to get around the problem (without making the database "read write",

> which would ruin the entire "hot stand-by" set up) ??

>

> Thanks.

>

> Alanoly Andrews.

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.