archivelog all format "/backup/data/arch_%T%U.arc"; delete noprompt backup of archivelog until time "sysdate archivelog all format "/backup/data/arch_%T%U.arc"; delete noprompt backup of archivelog until time "sysdate
’7’monthfromdual 当时时刻减去7年的时刻 selectsysdate,sysdate-interval’7’yearfromdual 时刻距离乘以一个数字 selectsysdate,sysdate
insert into test values(1,'SUSPEND',sysdate-12); insert into test values(1,'RESUME',sysdate-8); insert
o, dba_hist_snapshot sn where s.obj# = o.obj# and sn.snap_id = s.snap_id and begin_interval_time > sysdate
o, dba_hist_snapshot sn where s.obj# = o.obj# and sn.snap_id = s.snap_id and begin_interval_time > sysdate