I have a snapshot that I dropped; however, it left the table. When I query DBA_SNAPSHOTS the materialized view is not included. When I query DBA_OBJECTS it shows that the object is present as a table. When I try to drop the table it gives "ORA-12083: must use DROP MATERIALIZED VIEW ..." . When I try to drop the materialized view it gives "ORA-12003: materialized view 'xxxx' does not exist". When I try to rename it it gives "ORA-32318: cannot rename a materialized view" Any thoughts? ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------