Home » Server Options » Streams & AQ » Streams -- Joining mulitple tables and replicating to a single table (11.1.0.7)
Streams -- Joining mulitple tables and replicating to a single table [message #530699] Wed, 09 November 2011 16:29 Go to next message
naveenreddy
Messages: 10
Registered: August 2011
Junior Member
Hi,

Here is the scenario I am having trouble designing the solution for using streams.

I want to replicate the data that is the result of joining 3 tables to a single table in target database

Join Table1, Table2, Table3 and get few columns out of each table and replicate to Table A on the target side.

Can this be done using streams?

Thanks,
Naveen
Re: Streams -- Joining mulitple tables and replicating to a single table [message #530708 is a reply to message #530699] Wed, 09 November 2011 23:03 Go to previous message
Michel Cadot
Messages: 58599
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Previous Topic: AQ truncate
Next Topic: error remote table does not contain a primary key
Goto Forum:
  


Current Time: Mon Jul 28 05:47:04 CDT 2014

Total time taken to generate the page: 0.22340 seconds