您的位置:首页 > 博客中心 > 数据库 >

oracle 快照

时间:2022-03-10 17:50

select count(*) from atzserreportb

drop snapshot atzserreportb

Create snapshot atzserreportb as select * from atzserreportb@ORCL_Online;

Alter snapshot atzserreportb  refresh fast Start with sysdate+1/(24*60) next sysdate+10/(24*60); 

SELECT NAME,LAST_REFRESH FROM ALL_SNAPSHOT_REFRESH_TIMES;

select last_date,next_date,what from user_jobs order by next_date;

  create public database link 链路名  connect to 用户 identified by 口令 using ‘连接字符串‘;

oracle 快照,布布扣,bubuko.com

热门排行

今日推荐

热门手游