Re: Tablespace sharing in Oracle 7.3

"Antonio Sant" <asant_at_iol.it> wrote in message news:C2_c6.46311$ew1.3076773_at_news.infostrada.it...
> I'm wondering if this can be done:
>
> Suppose that we have 2 instance: A and B, on different server connected to
 a
> file server via high-speed network.
>
> What I'm tring to do is:
>
> Defining the two instance in the following way:
>
> A={ data_table_space1, index_table_space1} U {shared_data_table_space}
>
> B={shared_data_table_space}
>
> and work with them in this way:
>
> set shared_data_table_space offline, for A during the day so reports that
> work on B can have up to date information
>
> set shared_data_table_space offline, for B during the nigth batch process,
> so we can modify information from the A instance.
>
> The shared_data_table_space is marked as read-only for B and r/w for A.
>
> Any comments?
>
> Thanks for reading.
>
>

For what you try to accomplish you need Oracle Parallel Server. This will allow two instances to access one database. However all attributes of a tablespace are *global*, *always*. So either the tablespace is read/write for both instances or it is read only for both instances.
Evidently you need to use a separate *roles* which have appropiate privileges and are revoked and regranted at appropiate times. Alternatively, if you are afraid your data is going to be modified when you don't want that, you should lock the table when necessary. Please refer to the Oracle Concepts Manual for a discussion of concurrency.

Regards,

Sybrand Bakker, Oracle DBA Received on Sun Jan 28 2001 - 15:18:38 CST