从ora10g刷数据到8I基本操oracle账号作步骤
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"');