OraFAQ Forum: Replication » MVs associated with a MV LOG

Home » Server Options » Replication » MVs associated with a MV LOG (10.2.0.4)

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

MVs associated with a MV LOG [message #384859]

Thu, 05 February 2009 08:10

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

I have an MV Log in my database. is there any ways to find what are the MVs associated with this MVLog, from other databases ?

Report message to a moderator

Re: MVs associated with a MV LOG [message #384872 is a reply to message #384859]

Thu, 05 February 2009 09:05

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Check in the remote MV database which ones point to your table in dba_snapshots.

Regards
Michel

Report message to a moderator

Re: MVs associated with a MV LOG [message #384876 is a reply to message #384859]

Thu, 05 February 2009 09:52

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Thanks Mike, any ways to check from MV log side ? because i have many databases which connects each other .

Report message to a moderator

Re: MVs associated with a MV LOG [message #384879 is a reply to message #384876]

Thu, 05 February 2009 10:16

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you create a database link to the remote database then you can query from it otherwise no.

Regards
Michel

Report message to a moderator

Re: MVs associated with a MV LOG [message #384881 is a reply to message #384859]

Thu, 05 February 2009 10:35

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Sorry mike, i think you didnot get my question.

Suppose i have a database A , has few MV logs which are accessd by MVs in database B .

Does database A will have any dependency info stored about MVs in Database B ?

Thanks

Report message to a moderator

Re: MVs associated with a MV LOG [message #384882 is a reply to message #384881]

Thu, 05 February 2009 11:11

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I think you didn't get my answer. Smile

No, there is not.

Regards
Michel

Report message to a moderator

Re: MVs associated with a MV LOG [message #385190 is a reply to message #384882]

Sat, 07 February 2009 03:51

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

As per Mr Michel,

Try to find; using DBA_MVIEWS and DBA_MVIEW_LOGS

[Updated on: Sat, 07 February 2009 10:12] by Moderator

Report message to a moderator

Previous Topic:	Refresh snapshot data without logging (merged 3)
Next Topic:	Materialized VIEW flush scenario

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 17 20:25:39 CST 2024