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 »
Oracle »
Table »
Flashback Data Archives:
- Flashback Data Archives
- Alter a flashback archive
- Drop a flashback archive
Related: