| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-12083: must use DROP MATERIALIZED VIEW
Recreate the mview using the prebuilt table option, then try dropping the m=
view again.
create materialized view test on prebuilt table as select ... ;=20 drop materialized view test;
I ran into this one time. I forget if it was a bug or if my db link was do= wn. In any case I ended up with the quandary that you are in.
Jay
>>> tday6_at_csc.com 05/10/04 09:13AM >>>
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?
-- Archives are at http://www.freelists.org/archives/oracle-l/=20 FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html=20 ----------------------------------------------------------------- **DISCLAIMER This e-mail message and any files transmitted with it are intended for the = use of the individual or entity to which they are addressed and may contain= information that is privileged, proprietary and confidential. If you are n= ot the intended recipient, you may not use, copy or disclose to anyone the = message or any information contained in the message. If you have received t= his communication in error, please notify the sender and delete this e-mail= message. The contents do not represent the opinion of D&E except to the ex= tent that it relates to their official business. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon May 10 2004 - 14:43:02 CDT
 |
 |