oracle 物化视图 重建,重建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/，如需转载，请注明出处，否则将追究法律责任。