Hello,
we have a set of Materialized Views in one of our schemas that we can not remove anymore. This is on Oracle 11g R2. Here's an example:
SELECT object_id, object_name, object_type FROM user_objects WHERE object_name LIKE 'MV_WMS_AL_GEBAEUDE';
DROP MATERIALIZED VIEW MV_WMS_AL_GEBAEUDE;
SELECT object_id, object_name, object_type FROM user_objects WHERE object_name LIKE 'MV_WMS_AL_GEBAEUDE';
results in:
OBJECT_ID OBJECT_NAME OBJECT_TYPE
---------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------
863666 MV_WMS_AL_GEBAEUDE MATERIALIZED VIEW
DROP MATERIALIZED VIEW erfolgreich.
OBJECT_ID OBJECT_NAME OBJECT_TYPE
---------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------
863666 MV_WMS_AL_GEBAEUDE MATERIALIZED VIEW
There was also a table of the same name in the schema. I was able to delete that one with a simple 'DROP TABLE MV_WMS_AL_GEBAEUDE'.
Does anyone know why the drop statement fails to remove the MV?
Thanks,
Christian