I have a materialized view, but lost the original sql I used to create it. I now have to modify it. Does anyone know how to extract the ddl? Thanks Randy -- //www.freelists.org/webpage/oracle-l