I tried to drop two materialized views (one that I wanted to drop and the other as a test to make sure the behavior was consistent) in SQL Developer today, using the GUI, not the SQL command window. When I did this, since SQL Developer had these MVs in among the tables, it tried to run a "DROP TABLE" statement rather than a "DROP MATERIALIZED VIEW" and an ugly error message came along with that and of course it failed. Is this a bug that needs to be addressed? Or perhaps it's been identified already and being addressed in a future release?
Earl