OraFAQ Forum: Streams & AQ » How to Check the Bidirectional replication

Home » Server Options » Streams & AQ » How to Check the Bidirectional replication (Oracle 10.2.0.3 , Redhat-Linux)

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

How to Check the Bidirectional replication [message #397945]

Tue, 14 April 2009 12:07

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

babuknb
Messages: 1734
Registered: December 2005
Location: NJ

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

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

babuknb
Messages: 1734
Registered: December 2005
Location: NJ

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

varunvir
Messages: 389
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 28 12:42:46 CDT 2023