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))
Replication of data between different schemas at table level [message #452544] Thu, 22 April 2010 09:34 Go to next message
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.




[Updated on: Thu, 22 April 2010 09:37]

Report message to a moderator

Re: Replication of data between different schemas at table level [message #452560 is a reply to message #452544] Thu, 22 April 2010 10:33 Go to previous message
Michel Cadot
Messages: 59408
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Investigate DBMS_STREAMS_ADM package, especially RENAME_SCHEMA procedure.

Regards
Michel
Previous Topic: what are aq (merged)
Next Topic: ORA-24001 (merged)
Goto Forum:
  


Current Time: Tue Oct 21 11:07:32 CDT 2014

Total time taken to generate the page: 0.24280 seconds