Re: Snapshot Rep. between 2 schemas in same instance

Hi,

you could try materialized views. That is a kind of view, with some characteristics of replication. I think they can be updated both manually and automatically. Never used it myself, but it should work well in your situation.

Regards,

Johan

gfitzger_at_hotmail.com (Grant Fitzgerald) wrote in message news:<cdf183bb.0112170604.13678f62_at_posting.google.com>...
> 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 Tue Dec 18 2001 - 08:24:16 CET