Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't drop materialized view

Re: Can't drop materialized view

From: DJ <nospamplease_at_goaway.com>
Date: Tue, 21 Oct 2003 22:25:16 +0100
Message-ID: <1vhlb.550$vr5.497@newsfep4-winn.server.ntli.net>

"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
>

Its a table no?

drop table warenkorpos; Received on Tue Oct 21 2003 - 16:25:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US