RE: Materialized View

Sanjay,  

Are you asking who and where does a MV exist pointing back to a table in your database? If so, then the sql below can tell you this:    

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra Sent: Thursday, May 01, 2008 9:52 PM
To: oracle-l_at_freelists.org
Subject: Materialized View

How can we find that who is using this materialized view. I had a database where MV log is created and is very big but cannot purge as I am not aware who has created. How we can say that this Log is used by which server or site  

TIA
Sanjay

Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
<http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i6 2sR8HDtDypao8Wcj9tAcJ>

--
http://www.freelists.org/webpage/oracle-l