Home » Server Options » Streams & AQ » Multiple Master Databases, but one replication site
Multiple Master Databases, but one replication site [message #438552] Sun, 10 January 2010 21:08 Go to next message
patjose
Messages: 12
Registered: January 2010
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,

Report message to a moderator

Re: Multiple Master Databases, but one replication site [message #438580 is a reply to message #438552] Mon, 11 January 2010 01:25 Go to previous message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Is it possible to use streams to replicate the data from multiple Databases to one replication site?

Yes.

Quote:
If so, is there a way to identify the source of the dynamic data( for each record) in TEST in REP1?

Yes.

Streams Concepts and Administration

Regards
Michel

Report message to a moderator

Previous Topic: dequeue script hang or not functioning
Next Topic: Oracle Data Replication
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 12 07:06:54 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.