Re: Tablespace sharing in Oracle 7.3

this sounds like a really bad idea to me, and i don't see what you would gain from a setup like this. i am unaware of anything from oracle that would allow you to do something like this, other than parallel server.

i think it would be a better idea to have each server manage its own database, and implement a mechanism to replicate data between the two databases.

one alternative you might consider is creating a database link between the two instances to allow one instance to query data.

"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.
>
>
>
Received on Sun Jan 28 2001 - 21:45:36 CST