Oracle Replication [message #215027] |
Fri, 19 January 2007 00:49 |
kulsmadya
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?
|
|
|