how to replication in two oracle database

From: sun <soorajkg_at_gmail.com>
Date: 2 Apr 2006 17:31:47 -0700
Message-ID: <1144024307.170991.322270@u72g2000cwu.googlegroups.com>

I need help from any person who is having good knowledge of Oracle 8i/9i.

In My company , We have 2 databases( having same tables) at 2 different locations.

We have to Synchronize them Using replication. If any user is enterting data in 1st database same must be reflected in second database and vice-versa, This is the requirement.

At present I am Trying Trigger based replication

I have created database link between these 2 databases and have written triggers
in both the database i.e. I am doing trigger based replication.

But the problem in Trigger based replication is that If connectivity of databases(Which is through RF(Radio Frequency) breaks, Nobody can do entry, cause triggers wont execute in that case)

Can anybody help ??? Received on Sun Apr 02 2006 - 19:31:47 CDT