Fulltext results:

Oracle: Recovery Manager

3 Hits, Last modified: 12 years ago

e last 45 days: <code sql> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> To remove archive... p run: <code sql> DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> A sample script c... arget / << __EOF__ DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -3'; EXIT __EOF__ </code> {{tag