Re: partitioning

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Wed, 22 Oct 2003 05:49:10 GMT
Message-ID: <qTolb.14606$0i3.8936@news01.roc.ny>

"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:3F9548C8.305AEE02_at_remove_spam.peasland.com...
> > *THEN* put these "historycal data" tablespace in Read Only Mode and
>
> Yes, after you've moved the partition to the correct tablespace, put the
> tablespace in READ ONLY mode.
>
> > *THEN* sharing these tablespace between two Oracle instance (one for
> > production,one for testing/integration) ?
>
> Two instances cannot "share" the same tablespace unless you are using
> Real Application Clusters. But read on...
--snip--

Not wanting to nitpick ... however
The above statement is not entirely true. Two databases can share the same tablespace provided it follows the transportable tablespaces rules and both databases have access to the datafiles (i.e. for example if both databases are in the same server) and if the tablespace which is shared is set to "read only".

Admin manual states this.

Anurag Received on Wed Oct 22 2003 - 00:49:10 CDT