Hi
Thanks for the reply.
I am basically replicating an entire schema so I have to ensure referential integrity. I think I can accomplish that by using refresh groups (not if that is what you mean by table group consistency).
I understand that you mean I can use the old Oracle 8 way then?
Thanks
Alex
if you need no table group consistency then just create snapshot logs and snapshots.
------------------------------ *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *amonte *Sent:* 12. maí 2006 10:24 *To:* oracle-l@xxxxxxxxxxxxx *Subject:* Oracle 9.2 Basic Replication
Hi all
I am trying to replicate 50 tables from one database to another using Oracle 9.2.0.7 on Sun Solaris. this will be basic replication, read only MVs.
I am reading the replication manual (which talks about ADVANCED Replication) and it says I need to set up a master site and a materialized view site, then in master site create a replication administrator, proxy administrator etc (more steps).
My previous experience in basic replication goes back to Oracle 8, at that time I only hahd to create snapshots at snapshot site and create snapshot logs at master site and create a refresh group to ensure data integrity.
In 9.2 do I really need to perform all the tasks I mentioned or I can use the old Oracle 8 way?
TIA
Alex
Fyrirvari/Disclaimer http://www.landsbanki.is/disclaimer