===========================================================
Materialized View
===========================================================
作者: zhouwf0726(http://zhouwf0726.itpub.net)
发表于:2008.02.21 22:25
分类: oracle管理
出处：http://zhouwf0726.itpub.net/post/9689/455539
---------------------------------------------------------------
发表于:2008.02.21 22:25
分类: oracle管理
出处：http://zhouwf0726.itpub.net/post/9689/455539
---------------------------------------------------------------
Materialized View
--fc1cn
create materialized view log on FC_BJ_PROD_USER.BIN_ITEMS tablespace ADMINISTRATOR;
--create materialized view on fcdw1cn
CREATE SNAPSHOT FC_BJ_PROD_USER.BIN_ITEMS_BAK REFRESH FAST AS SELECT * FROM FC_BJ_PROD_USER.BIN_ITEMS@FC1CN.AMAZON
--create materialized view on fcdw1cn
--exec dbtools_run_as('BOOKER','select * from v$database');
exec dbms_snapshot.refresh(list=>'FC_BJ_PROD_USER.BIN_ITEMS_BAK', method=>'f');
EXEC dbms_refresh.make(name=>'REPADMIN.SNAP_FC1CN',list=>NULL,next_date=>SYSDATE,interval=>'SYSDATE+(2/(24 * 60))',lax=>TRUE);
EXEC dbms_refresh.add (name=>'REPADMIN.SNAP_FC1CN', list=>'FC_BJ_PROD_USER.BIN_ITEMS_BAK', lax => TRUE);
EXEC DBMS_REFRESH.REFRESH('REPADMIN.SNAP_FC1CN');
exec dbms_job.run(...);