OraFAQ Forum: Streams & AQ » Replication of data between different schemas at table level

Home » Server Options » Streams & AQ » Replication of data between different schemas at table level (Oracle 10.2.0.4 and OS is Solaris 32 Bit, (Solaris 10))

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

Replication of data between different schemas at table level [message #452544]

Thu, 22 April 2010 09:34

rtjk
Messages: 33
Registered: February 2005

Member

Hi,

Can someone provide the steps for oracle streams replication between different schemas in oracle 10.2.0.4.0 at table level.OS is Solaris 10(32 bit).Both source and destination db have same OS and Database level

I tested for Scott's emp table@database1[/email][/email] to scott's emp table@database2.[/email][/email]

But I want to replicate from Scott's emp table@database1[/email][/email] to test's emp table@database2.And[/email][/email] it is not working.I don't want to do schema level replication.

EMP table structure in test and Scott's are similar.

can someone help.