Топ-100
 

ALTER FLASHBACK ARCHIVE

Описания команд доступны в программе CerebroSQL

RDBMS Type: Oracle
Topic

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