Multiple Master Databases, but one replication site [message #673344] |
Thu, 15 November 2018 22:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/bb9078679e3b959973556518ff42f0ca?s=64&d=mm&r=g) |
kullboys
Messages: 2 Registered: November 2018
|
Junior Member |
|
|
Hi
Is it possible to use streams to replicate the data from multiple Databases to one replication site?
Table TEST exists in databases DB1, DB2, DB3 but with different data. I'd like to get data from all these 3 databases to another replication DB, REP1.
Is it possible? If so, is there a way to identify the source of the dynamic data( for each record) in TEST in REP1?
Env is Oracle10.2.0.3,Solaris 5.8.
Thanks.
|
|
|
|
Re: Multiple Master Databases, but one replication site [message #673352 is a reply to message #673344] |
Fri, 16 November 2018 01:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Is it possible to use streams to replicate the data from multiple Databases to one replication site?
Yes it is possible.
Quote: If so, is there a way to identify the source of the dynamic data( for each record) in TEST in REP1?
Add a column with the source information.
You can add a column in the LCR using DBMS_STREAMS_ADM.ADD_COLUMN and "source_database_name" field of the LCR to fill it or in a DML handler you can use ADD_COLUMN method the LCR to add the column.
|
|
|