OraFAQ Forum: Streams & AQ » Streams -- Joining mulitple tables and replicating to a single table

Home » Server Options » Streams & AQ » Streams -- Joining mulitple tables and replicating to a single table (11.1.0.7)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Streams -- Joining mulitple tables and replicating to a single table [message #530699]

Wed, 09 November 2011 16:29

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

Report message to a moderator