Synching Two Databases

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. Received on Fri Sep 30 2005 - 13:43:21 CDT