Re: Synching Two Databases

you can use Oracle multimaster replication.

Not sure what is yr requirement of copying them into temp table and then
moving to another DB. This will keep yr tables sync.

See the below link, if it can help you.

http://www.oracle-base.com/articles/8i/AdvancedReplication.php

Regards - Chirag

IANAL_VISTA wrote:
> "raghu" <raghu_vnin_at_yahoo.com> wrote in
> news:1128105801.415887.8260_at_o13g2000cwo.googlegroups.com:
>
> > We are planning to sync several tables between two Oracle9i databases.
> > The replication approach is like this:
> > a. Copy all the changes in the first db to a temporary table through a
> > trigger
> > b. Apply the changes to the second db through a scheduled procedure.
> > c. Mark the record as copied in the temporary table in the first db.
> >
> > Changes will be blocked in the second db and hence the synching is only
> > one-way.
> > 1. Now, I am interested in knowing the possible issues/failures in this
> > solution. Are there any chances of errors while copying the data from
> > the temporary table to the second db, marking the records in the temp
> > table as copied, or any other scenarios where this design could break?
> > 2. Can we have a transaction of a set of records and do a commit only
> > if all of them succeed?
> >
> > Thanks.
> >
>
> What happens with deleted records?
Received on Mon Oct 03 2005 - 10:19:39 CDT