Re: locally managed tspc and standby database

Hanan Bar On wrote:
>
> hi all,
>
> I have a standby database and i want to change my temporary tbsp
> to locally managed tablespace in the primary database.
> on the standby database , do i write the same syntax of
> "alter database create datafile <filename1> as <filename2>"
> even tough it's tempfile and not datafile ?
>
> thanks,
>
> Hanan

sqlplus> alter database backup controlfile to trace;

grab the file out of the user_dump_dest and read it. You don't need a temp tablespace on the standby until you want to open it (read-only)
or activate it.

hth,

Paul Received on Tue Aug 28 2001 - 01:14:41 CDT