Oracle 9.2 Basic Replication

  • From: amonte <ax.mount@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 12 May 2006 12:24:09 +0200

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

Other related posts: