OraFAQ Forum: Streams & AQ » Oracle Stream in same schema

Home » Server Options » Streams & AQ » Oracle Stream in same schema

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

Oracle Stream in same schema [message #260611]

Mon, 20 August 2007 08:04

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

Report message to a moderator

Re: Oracle Stream in same schema [message #260621 is a reply to message #260611]

Mon, 20 August 2007 08:37

Michel Cadot
Messages: 68257
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

Report message to a moderator

Re: Oracle Stream in same schema [message #260625 is a reply to message #260621]

Mon, 20 August 2007 08:56

toshidas2000
Messages: 120
Registered: November 2005

Senior Member

Thanks I need for 9i. The do not have for same schema and same database..

Report message to a moderator

Re: Oracle Stream in same schema [message #260659 is a reply to message #260625]

Mon, 20 August 2007 11:21

Michel Cadot
Messages: 68257
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

Report message to a moderator

Re: Oracle Stream in same schema [message #262735 is a reply to message #260611]

Tue, 28 August 2007 03:12

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.

Report message to a moderator

Previous Topic:	Issues in dropping an Apply process
Next Topic:	How to send Oracle AQ to ESB using Message Gateway

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 09 03:42:40 CDT 2022