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,
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: 68624
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.

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
Previous Topic: dequeue script hang or not functioning
Next Topic: Oracle Data Replication
Goto Forum:
  


Current Time: Thu Mar 28 09:21:16 CDT 2024