重建oracle 物化视图

SELECT 'CREATE MATERIALIZED VIEW LOG ON '||a.LOG_OWNER||'.'||a.MASTER||' TABLESPACE '||b.tablespace_name || case when a.rowids = 'YES' then ' WITH ROWID;'
             when a.primary_key = 'YES' then ' WITH PRIMARY KEY;'
        end mv_col
FROM DBA_MVIEW_LOGS a,dba_segments b
WHERE a.LOG_OWNER IN ('IB1', 'BL1','BS1','CM1','CR1','CS1','DL1','DP1','EI1'
          ,'FX1','GA1','GL1','HQ1','IF1','IR1','LN1','RT1'
          ,'TF1','EAI','EXIT','RACE','HP1','CD1','RC1')
     and a.log_table = b.segment_name(+)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21634752/viewspace-691787/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21634752/viewspace-691787/