Alter a flashback archive

The following statement changes the data retention period to 2 years:


ALTER FLASHBACK ARCHIVE test_archive
MODIFY RETENTION 2 YEAR;

You can purge the data from a flashback archive before a given timestamp:


ALTER FLASHBACK ARCHIVE test_archive
PURGE BEFORE TIMESTAMP(SYSTIMESTAMP - INTERVAL '1' DAY);

You can purge all the data in a flashback archive:


ALTER FLASHBACK ARCHIVE test_archive PURGE ALL;
Home »
Oracle »
Table » 

Flashback Data Archives:
  1. Flashback Data Archives
  2. Alter a flashback archive
  3. Drop a flashback archive
Related: