Home » Server Options » Streams & AQ » Streams - Multiple Capture process (Oracle EE,2 Node RAC,11.2.0.2,RHEL5)
Streams - Multiple Capture process [message #537488] Wed, 28 December 2011 23:00 Go to next message
arunb1982
Messages: 34
Registered: December 2010
Location: Bangalore
Member
Hi,

I have databases DB1 and DB2 running on the same server.
DB1 has table T1 and DB2 has table T2.

Can I use streams to capture the changes from T1 and T2 and apply to database DB3 on a different server as table T1 and table T2?

Thanks,
Arun
Re: Streams - Multiple Capture process [message #537510 is a reply to message #537488] Thu, 29 December 2011 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Re: Streams - Multiple Capture process [message #537521 is a reply to message #537510] Thu, 29 December 2011 02:46 Go to previous message
arunb1982
Messages: 34
Registered: December 2010
Location: Bangalore
Member
Thanks Michel Smile
Previous Topic: ORA-26753: Mismatched columns found in 'DBO.TEST'
Next Topic: Adding new Column in CDC table
Goto Forum:
  


Current Time: Thu Mar 28 17:20:34 CDT 2024