Re: Snapshot Rep. between 2 schemas in same instance

Sorry, I should also have mentioned that we will probably have several admin users all updating data over a period of a few days before the data is made available to the normal users.

Grant

gfitzger_at_hotmail.com (Grant Fitzgerald) wrote in message news:<cdf183bb.0112170222.42ba72ba_at_posting.google.com>...
> Hi,
>
> I need to have two copies of my data within one instance. One
> copy is updateable by an admin user and the other copy is read-
> only by other users. The problem is that I want to allow the
> admin user to update the data without the others being affected
> until the admin user decides that the new data is to be made
> available i.e. normal users work with the old data until the
> admin user is finished entering the new data.
>
> My initial idea is to use read-only snapshot replication to
> provide the normal users with snapshots of the admin user's
> data. Then, when the admin user finishes entering new data a
> refresh can be done and all the other users can then see the new
> data.
>
> Is this a sensible way to do things? Should I be using a second
> instance? This would no doubt increase the licensing costs? I am
> relatively new to Oracle so am not sure if there is a better way
> to achieve what I need.
>
> Thanks for any advice,
> Grant Fitzgerald
Received on Mon Dec 17 2001 - 15:04:22 CET