Home » Server Options » Replication » MVs associated with a MV LOG (10.2.0.4)
MVs associated with a MV LOG [message #384859] Thu, 05 February 2009 08:10 Go to next message
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 ?
Re: MVs associated with a MV LOG [message #384872 is a reply to message #384859] Thu, 05 February 2009 09:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check in the remote MV database which ones point to your table in dba_snapshots.

Regards
Michel
Re: MVs associated with a MV LOG [message #384876 is a reply to message #384859] Thu, 05 February 2009 09:52 Go to previous messageGo to next message
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 .
Re: MVs associated with a MV LOG [message #384879 is a reply to message #384876] Thu, 05 February 2009 10:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you create a database link to the remote database then you can query from it otherwise no.

Regards
Michel
Re: MVs associated with a MV LOG [message #384881 is a reply to message #384859] Thu, 05 February 2009 10:35 Go to previous messageGo to next message
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
Re: MVs associated with a MV LOG [message #384882 is a reply to message #384881] Thu, 05 February 2009 11:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you didn't get my answer. Smile
No, there is not.

Regards
Michel
Re: MVs associated with a MV LOG [message #385190 is a reply to message #384882] Sat, 07 February 2009 03:51 Go to previous message
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:
  


Current Time: Thu Mar 28 09:21:25 CDT 2024