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: Markus Boehmer <markus.boehmer_at_schaefer-shop.de>
Date: Wed, 22 Oct 2003 08:08:19 +0200
Message-ID: <bn5a3l$3lu$1@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
Received on Wed Oct 22 2003 - 01:08:19 CDT












Original text of this message













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