Home » RDBMS Server » Server Administration » Oracle Replication
icon9.gif  Oracle Replication [message #215027] Fri, 19 January 2007 00:49
Messages: 1
Registered: January 2007
Junior Member
I want to have 2 instances of the DB where one instance will have modified tables(added columns or modified procedures). But I want to replicate the information which is inserts?ed/updated/deleted from 1 instance to another or vice a versa.

e.g. DB1 will have table called user which will have columns UID, UNAME and in DB2 will have same table name with added column ULNAME. 2 applications accessing these 2 instances can insert/update/delete information. But I want to keep the data of these 2 tables in 2 DB instances as updated as it gets changed.
If I add U10 in DB1/USER, it should be available in DB2/USER table as well with ULNAME as null.

How can I achieve this?
Previous Topic: Redo log Files and RAID5
Next Topic: Running Oracle9 db and oracle 10g db
Goto Forum:

Current Time: Wed Oct 26 16:09:31 CDT 2016

Total time taken to generate the page: 0.10894 seconds