Members   Search   Help    Register    Login   Home
Home » Server Options » Streams & AQ » How to Check the Bidirectional replication (Oracle 10.2.0.3 , Redhat-Linux)
How to Check the Bidirectional replication [message #397945] Tue, 14 April 2009 12:07 Go to next message
girishta
Messages: 30
Registered: December 2006
Member
Hi,

How to check whether the Oracle streams is configured with Bidirectional / Unidirectional replication.

Thanks & regards
Girish
Report message to a moderator
Re: How to Check the Bidirectional replication [message #398036 is a reply to message #397945] Wed, 15 April 2009 00:03 Go to previous messageGo to next message
gentlebabu
Messages: 1382
Registered: December 2005
Location: India, Hyderabad
Senior Member
 
 bi_directional       => true,


Babu
Report message to a moderator
Re: How to Check the Bidirectional replication [message #398062 is a reply to message #398036] Wed, 15 April 2009 01:49 Go to previous messageGo to next message
girishta
Messages: 30
Registered: December 2006
Member
Hi,

I'm aware of that configuration ... but i want the dictionary view to see this is option bidirectional ==> true option

Thanks,
Girish
Report message to a moderator
Re: How to Check the Bidirectional replication [message #398476 is a reply to message #398062] Thu, 16 April 2009 06:45 Go to previous messageGo to next message
gentlebabu
Messages: 1382
Registered: December 2005
Location: India, Hyderabad
Senior Member

Sorry; I'm not able to find any data dictionary table.

But I was thinking there is NO data dictionary table but some other ways available (like using Rules) we can find. (I guess).

Babu
Report message to a moderator
Re: How to Check the Bidirectional replication [message #399726 is a reply to message #398476] Thu, 23 April 2009 14:16 Go to previous message
varunvir
Messages: 247
Registered: November 2007
Senior Member
You can check dba_capture,v$streams_capture for that.
You can check in dba_streams_rules also.
Regards,
Varun Punj,
Report message to a moderator
Previous Topic:ORA-26714: User error encountered while applying --> on streams
Next Topic:Schema Stream replication have Error ORA-26687: no instantiation SCN provided
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 8 16:53:31 CST 2009

Total time taken to generate the page: 0.43086 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.