Can't drop materialized view

From: Markus Boehmer <markus.boehmer_at_schaefer-shop.de>
Date: Tue, 21 Oct 2003 21:07:44 +0200
Message-ID: <bn43d3$dnt$1@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 Tue Oct 21 2003 - 14:07:44 CDT