Synchronize table level data in two Oracle databases

[Sripradha]

Hi,

I have a requirement of synchronizing table data in two Oracle databases( For ex: I need to synchronize the tables with their data to be exactly the same in both development and test environments). I basically will have to sync up the database tables to have the same data both in Development environment and Test environment. The dev database resides in one database d1_db@devdb.world and the test database resides in another database named t1_db@testdb.world.

Can someone help me in synchronizing the table level information in both the databases?

Thanks!
Sri.

[skhanal]

You can use Oracle Streams to do that. It is more complicated to sync up both directions.

If it is only few tables you can also create dblinks and create triggers to update remote database.