物化视图SQL
物化视图SQL，如果没有结果集，就证明数据库中不存在物化视图
1 select a.owner,'' column_name,a.table_name,b.segment_name,b.segment_type, 2 ROUND(b.BYTES / 1024 / 1024) fp_mb 3 from DBA_VIEWS a, dba_segments b 4 where a.owner = 'COGLINK' and a.VIEW_NAME = b.segment_name ;
物化视图SQL，如果没有结果集，就证明数据库中不存在物化视图
1 select a.owner,'' column_name,a.table_name,b.segment_name,b.segment_type, 2 ROUND(b.BYTES / 1024 / 1024) fp_mb 3 from DBA_VIEWS a, dba_segments b 4 where a.owner = 'COGLINK' and a.VIEW_NAME = b.segment_name ;
