Re: Standby Oracle 8i server as report server - Error!

Jonathan Lewis wrote:

> Sorry, I don't know.
>
> When I read up the details on Temporary tablespaces
> and using standby databases for reporting I assumed
> that
>
> a) I would not be able to create a new tablespace on the
> standby database, only add files to an existing temporary
> tablespace.
>
> b) I wouldn't want to have anything other than a proper
> temporary tablespace on production every again. Note
> particularly - when you backup a database with a proper
> temporary tablespace, the files for the temporary tablespace
> ARE NOT backed up. (at least using the 'standard' tools)
> since the files are listed in v$tempfile rather than v$datafile
> (and dba_temp_files rather than dba_data_files).
>
> Anyway why would you want to drop the tablespace
> before opening the standby database for production ?
>
> --
>

Can I add tamporary tablespace to my production database before add it to standby database? Can I add tamporary tablespace only to standby database and continue sync it with production database? Thanks.
Alexander.

>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Alex Andr. wrote in message <38687292.DE10FBA7_at_uqcd.poltava.ua>...
> >Thanks all for replay. If I add temporary tablespace can I drop it before
> >open Standby Database for production?
> >
Received on Mon Jan 03 2000 - 01:48:12 CST