Can't drop table/ materialized view
229233Jul 17 2006 — edited Jul 18 2006Hello,
I have a materialized view that cannot be dropped whether I try to drop it as a table or materialized view. Oracle says it drops the materialized view OK but when I try and create a table with the same name it says that the name is already in use!
Below is an example script of the problem. I am running on Oracle 10g.
DROP TABLE VIC_86173_18
ORA-12083: must use DROP MATERIALIZED VIEW to drop "QA"."VIC_86173_18"
DROP MATERIALIZED VIEW VIC_86173_18
Snapshot dropped
CREATE TABLE VIC_86173_18
(GEOMETRY MDSYS.SDO_GEOMETRY,lga_polygon_pid VARCHAR2(15),
date_created DATE,date_retired DATE,lga_pid VARCHAR2(15))
ORA-00955: name is already used by an existing object
Thanks
Bronwyn