Re: Oracle 9.2 Basic Replication

  • From: amonte <ax.mount@xxxxxxxxx>
  • To: Laimutis.Nedzinskas@xxxxxxxxxxxxx
  • Date: Fri, 12 May 2006 12:37:29 +0200

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


On 5/12/06, Laimutis Nedzinskas <Laimutis.Nedzinskas@xxxxxxxxxxxxx> wrote: 

 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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2006