Home » Server Options » Streams & AQ » Oracle Stream in same schema
Oracle Stream in same schema [message #260611] Mon, 20 August 2007 08:04 Go to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
All
I need help in replicating a table A to table B in same schema and same database. I want replication both side. If Table A changes, change should be replicated to Table B and vice versa. I am new to oracle streams, please help or link to any documentation will be helpful too...

Thanks
Toshi
Re: Oracle Stream in same schema [message #260621 is a reply to message #260611] Mon, 20 August 2007 08:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.oracle.com/pls/db102/portal.portal_db?selected=3#index-STR

Regards
Michel
Re: Oracle Stream in same schema [message #260625 is a reply to message #260621] Mon, 20 August 2007 08:56 Go to previous messageGo to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
Thanks I need for 9i. The do not have for same schema and same database..
Re: Oracle Stream in same schema [message #260659 is a reply to message #260625] Mon, 20 August 2007 11:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think you can as you must have source and destination link with different names but Streams requires the database link has the same name as the database (parameter global_name=true).

Regards
Michel
Re: Oracle Stream in same schema [message #262735 is a reply to message #260611] Tue, 28 August 2007 03:12 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
the database link has the same name as the database

Yes this is needed of course in stream.
Rather than database I want to mention "global database name."
So by changing global database name you can do that.
Previous Topic: Issues in dropping an Apply process
Next Topic: How to send Oracle AQ to ESB using Message Gateway
Goto Forum:
  


Current Time: Thu Mar 28 13:16:15 CDT 2024