Yep. That 's the trick. I recreated the snapshot using a 'where 1=0 '
clause, dropped the snapshot, and was then able to drop the table. It also
unregistered it on the master site. Thanks.
"Jay Hostetter "
<jhostetter To: Thomas Day/CIV/SC/CSC@(protected), <oracle-l@(protected) >
@(protected) cc:
s.com > Subject: Re: ORA-12083 (See ORA-12083.ora-code.com): must use DROP MATERIALIZED VIEW
05/10/2004 03:46
PM
Recreate the mview using the prebuilt table option, then try dropping the
mview again.
create materialized view test on prebuilt table as select ... ;
drop materialized view test;
I ran into this one time. I forget if it was a bug or if my db link was
down. In any case I ended up with the quandary that you are in.
Jay
> > > tday6@(protected) 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.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
**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
not 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
this 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 extent 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
