从ora10g刷数据到8I基本操作步骤

删除快照日志（可选）
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"');