Take a look at dba_dependencies and see if your MView log and related dependencies live there. I'm not sure if mview logs with dependent mviews are listed there or not and I can't test it just now. RF -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx To: oracle-l@xxxxxxxxxxxxx Sent: 11/23/2004 11:26 AM Subject: ** mv log Hi, Recently I incresed the column length in a table that has a materialized view log on it. Update to the column with increased length is not working. I am planning to recreate the mv log. Before that I would like to extract the mv log definition so I can use the same for re-creating it. I want to be careful and follow the exact steps. Anything else I need to do? I did find the table mlog$_<table_name>. I assume this gets created when the mv log is created. When I delete the mv log then I assume all objects that depend on the mv log have to be complete refreshed. There could be objects in other databases that depend on it and I do not know how to find those. What would happen if I delete the mv log and recreate it and after that one of the dependent objects tries to do a refresh. Will it get an error or will it just changes after the re-creation. Thanks for your help. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l