Топ-100
 
CerebroSQL

ALTER FLASHBACK ARCHIVE

RDBMS Type: Oracle

unnamed (2).png

ALTER FLASHBACK ARCHIVE flashback_archive
{ SET DEFAULT
| { ADD | MODIFY } TABLESPACE tablespace [flashback_archive_quota]
| REMOVE TABLESPACE tablespace_name
| MODIFY RETENTION flashback_archive_retention
| PURGE { ALL | BEFORE { SCN expr | TIMESTAMP expr } }
| [NO] OPTIMIZE DATA
};

QUOTA integer { M | G | T | P | E }
RETENTION integer {YEAR | MONTH | DAY}

Example