从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"');

1楼royjj5天前 14:08

8i中如果不知道具体的其他命令选项，可以通过oem 来配置 snapshot。