从ora10g刷数据到8I基本操作步骤
从ora10g刷数据到8I基本操作步骤
master :oracle 10g
snapshot site: oralce 8i
在oracle 8i 中物化视图称为快照，oracle 8i建快照的sql 命令在oracle10g依然是兼容的。
on master site:
删除快照日志（可选）
drop snapshot log on xxxx;
drop snapshot log on xxxx;
重建快照日志
CREATE SNAPSHOT LOG ON xx TABLESPACE "TS_SNAPSHOT_LOG" ;
CREATE SNAPSHOT LOG ON xxx TABLESPACE "TS_SNAPSHOT_LOG" ;
on snapshot site:
删除快照(快照)
drop SNAPSHOT xxx;
drop SNAPSHOT xxxx;
重建快照
CREATE SNAPSHOT xxx TABLESPACE "xxx" REFRESH FAST START WITH sysdate NEXT sysdate+30/1440 AS select * fromxxx@xxx;
CREATE SNAPSHOT xxx TABLESPACE "TS_SNAPSHOT" REFRESH FAST START WITH sysdate NEXT sysdate+30/1440 AS select * from xxxx@xxxx;
手工刷新
execute dbms_refresh.refresh('"xxxx"."xxxxx"'); execute dbms_refresh.refresh('"xxxx"."xxxxx"');
