Oracle 9.2 Basic Replication

From: amonte <ax.mount_at_gmail.com>
Date: Fri, 12 May 2006 12:24:09 +0200
Message-ID: <85c1fb130605120324u47d276dap6adc7fbde55b20a9@mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 12 2006 - 05:24:09 CDT