I dropped a materialized view (without the preserve table option), but the object still exists! Here’s a copy and paste from my session:
drop materialized view gone_for_good; materialized view GONE_FOR_GOOD dropped. select or_is_it from gone_for_good; OR_IS_IT -------- Nope! -- covering off the easy option, -- there isn't a (public) synonym -- with the same name: select * from all_synonyms where synonym_name = 'GONE_FOR_GOOD'; no rows selected
How did this happen? Answers in the comments!