Re: Can't drop materialized view

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Wed, 22 Oct 2003 06:29:06 GMT
Message-ID: <Ssplb.14685$jv3.8486@news01.roc.ny>

"Markus Boehmer" <markus.boehmer_at_schaefer-shop.de> wrote in message news:bn5a3l$3lu$1_at_news.dtag.de...
> >
> > Its a table no?
> >
> > drop table warenkorpos;
> >
> >
>
> No, it isn't.
> Like I said, it is an Materialized view.
>
>
> SQL> drop table warenkorbpos;
> drop table warenkorbpos
> *
> ERROR at line 1:
> ORA-12083: must use DROP MATERIALIZED VIEW to drop
> "THESAURUS"."WARENKORBPOS"
>
>
> Regards
> Markus
>

What is the output of the following:

select * from all_mviews where mview_name = 'WARENKORBPOS';

Anurag Received on Wed Oct 22 2003 - 01:29:06 CDT