Hello,
I have a weird problem with a materialized view I am trying to get rid of.
I tried dropping it a few times, but it keeps coming back. SQLDeveloper is not displaying it in the object tree, but it is still there when I do a Database Export and I can keep executing a "drop materialized view" statement...
For easier demonstration of the problem I ran through the below SQLPlus session:
SQL> drop materialized view RMP_CSC_MESSAGE_XML_BY_TYPE2;
Materialized view dropped.
SQL> commit;
Commit complete.
SQL> drop materialized view RMP_CSC_MESSAGE_XML_BY_TYPE2;
Materialized view dropped.
SQL> commit;
Commit complete.
SQL> purge recyclebin;
Recyclebin purged.
SQL> drop materialized view RMP_CSC_MESSAGE_XML_BY_TYPE2;
Materialized view dropped.
What is happening here????
How do I get rid of this MView?
Thank you in advance...