Re: Synching Two Databases

"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 Fri Sep 30 2005 - 20:37:30 CDT