cannot drop materialized view and it's not showing in all_snapshots
We are having some problems with some materialized view. When we try to drop the materialized view. It says:
Materialized view dropped.
But, we still are able to make queries on it.
When we tried to look it up in all_snapshots, it's not there. But, when we checked dba_objects, we still see the listing (one for table, one for Materialized View.)
Has anyone else seen this issue?
Materialized view dropped.
But, we still are able to make queries on it.
When we tried to look it up in all_snapshots, it's not there. But, when we checked dba_objects, we still see the listing (one for table, one for Materialized View.)
Has anyone else seen this issue?
0