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(...);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/756652/viewspace-242507/ ，如需转载，请注明出处，否则将追究法律责任。
