Feb 242014

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;


-- 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!