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://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ