Cannot Drop Materialized View
I have a materialized view that I moved to another schema for various reasons. When I try to drop the materialized view (drop materialized view command) it says that it has been dropped. However when I review the list of tables in that schema it still appears. If I try to drop it as a table I get an error stating that you cannot drop a materialized view in this way.
This is occurring on my test database so it's certainly not an emergency though it is driving me nuts! Thanks in advance for any help you can provide!
Matt Allen
0