-- List of MATERIALIZED VIEW: SELECT * FROM DBA_MVIEWS; -- or ALL_MVIEWS SELECT * FROM DBA_OBJECTS WHERE OBJECT_TYPE = 'MATERIALIZED VIEW'; -- or ALL_OBJECTS
-- List of MATERIALIZED VIEW: SELECT * FROM DBA_MVIEWS; -- or ALL_MVIEWS SELECT * FROM DBA_OBJECTS WHERE OBJECT_TYPE = 'MATERIALIZED VIEW'; -- or ALL_OBJECTS