Also check to see if there are synonyms present on that MV. if so delete
them too.
"Markus Boehmer" <markus.boehmer_at_schaefer-shop.de> wrote in message
news:bn43d3$dnt$1_at_news.dtag.de...
> Hello everybody,
>
> I have a strange problem with my Oracle 9iR2 on sun solaris.
> I have a materialized view called WARENKORBPOS.
>
> SQL> select table_name, owner
> 2 from all_tables
> 3 where table_name = 'WARENKORBPOS';
>
> TABLE_NAME OWNER
> ------------------------------ ------------------------------
> WARENKORBPOS THESAURUS
>
>
> The MView is empty:
> SQL> select count(*) from warenkorbpos;
>
> COUNT(*)
> ----------
> 0
>
>
> I'm connected as the owner from the view:
> SQL> select user from dual;
>
> USER
> ------------------------------
> THESAURUS
>
>
>
> But I can't drop it:
>
> SQL> drop MATERIALIZED VIEW warenkorbpos;
> drop MATERIALIZED VIEW warenkorbpos
> *
> ERROR at line 1:
> ORA-12003: materialized view "THESAURUS"."WARENKORBPOS" does not exist
>
>
>
> I hope you have any suggestions on this or am I only too dumb to do this
> correct?
>
> Greetings
> Markus
>
Received on Wed Nov 05 2003 - 21:05:06 CST
