Re: Synching Two Databases

On 30 Sep 2005 11:43:21 -0700, "raghu" <raghu_vnin_at_yahoo.com> wrote:

>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.

You are aware Oracle comes with Replication facilities? Why write your own?

--
Sybrand Bakker, Senior Oracle DBA