DELETE noprompt ARCHIVELOG ALL COMPLETED BEFORE '(SYSDATE-時間)';
DELETE noprompt ARCHIVELOG UNTIL TIME 'SYSDATE-時間';
保留1天 sysdate -1
保留12小時 sysdate - 1/2
保留1小時 sysdate - 1/24
DELETE noprompt ARCHIVELOG ALL COMPLETED BEFORE '(SYSDATE-時間)';
DELETE noprompt ARCHIVELOG UNTIL TIME 'SYSDATE-時間';
保留1天 sysdate -1
保留12小時 sysdate - 1/2
保留1小時 sysdate - 1/24
![oracle中的start with connect by用法[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)