Tag Info

New answers tagged

0

I faced similar issue when i tried to drop materialized view it says View doesn't exist. If I try to create it, it says Name already exists. This is a bug in Oracle. Before dropping view, query on all_objects table. SQL : SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME ='MY_MVIEW'; It should return 2 records, ojbect_type = TABLE and Object_type = MATERIALIZED ...


1

This is assuming that materialized views have relpages >= 8 in pg_class, which doesn't have to be the case. An MV can actually be empty. It does not have to be populated, yet, indicated by pg_class.relispopulated = FALSE. The corresponding disk file has a zero size in this case. Try instead: SELECT relname AS objectname , relkind AS objecttype ...



Top 50 recent answers are included