Re: Standby Oracle 8i server as report server

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 29 Dec 1999 12:50:52 -0000
Message-ID: <946472001.23847.0.nnrp-14.9e984b29@news.demon.co.uk>

Sorry, I don't know.

When I read up the details on Temporary tablespaces and using standby databases for reporting I assumed that

I would not be able to create a new tablespace on the standby database, only add files to an existing temporary tablespace.
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 ?

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 Wed Dec 29 1999 - 06:50:52 CST

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