Re: Standby database under 8i - 'create temp tablespace'?

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 3 May 2006 11:22:05 -0700
Message-ID: <1146680525.636873.224350@i40g2000cwc.googlegroups.com>

BD wrote:
>
> I'm on 8.1.7.4 on AIX.
>
>
> So if I have all of the real 'datafiles', but no temp tablespace files,
> how can I create a new temp tablespace in a standby db? The online docs
> discuss the addition of datafiles, but they always assume you have the
> original datafile from the master to transfer to the standby.
>

You don't need temporary tablespaces for standby recovery, they are only needed when you switch standby to read-only mode for querying. You can safely create temporary tablespaces provided that they consist of tempfiles and are locally managed. You can also add tempfiles to existing temporary tablespaces in read-only mode. And a quote from Oracle8i Standby Database Concepts:

"User-level allocations and permissions to use the locally managed temporary tablespaces must be in place on the primary database. You cannot change these settings on the standby database."

For more information see Standby Database Concepts, Chapter 3, "Managing A Standby Database", "Opening Standby Database in Read-Only Mode".

Hth,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Wed May 03 2006 - 13:22:05 CDT