Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Synch between TWO Tables in Different Databases

3888Nov 17 2003 — edited Nov 18 2003

Synch between Two Tables in two different Databases.

I have two identical tables, table T1 in Database D1 and table T1 in Database D2. User can insert/update/delete/select from both of these tables in respective databases. Being said that how can keep them in Synch? Any thing added/modified/deleted should reflect in other. We like this to be Real-Time.

We are thinking of creating a cross (two way) DB link between them and then update/insert/delete both the tables when changing one.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 16 2003

Added on Nov 17 2003

#general-database-discussions

12 comments

2,682 views