摘要:
一、建立快照日志
create snapshot log on full_information;
二、建立数据库链
Create database link link_TSZX
Connect to wll identified by wll using 'intszx';
三、验证
select *from full_information@link_tszx;
四、建立快照:
create snapshot full_information as select *from full_information@link_tszx;
五、建立刷新:
Alter snapshot full_information refresh fast
Start with sysdate+1/1440 next sysdate+1/144;
阅读全文