Did you check this: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_d atabase_id=3DNOT&p_id=3D148379.1 Regards, Waleed -----Original Message----- From: Thomas Day [mailto:tday6@xxxxxxx] Sent: Monday, May 10, 2004 9:13 AM To: oracle-l@xxxxxxxxxxxxx Subject: ORA-12083: must use DROP MATERIALIZED VIEW=20 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------