oracle 10g dbms 8i,从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"');