top of page
CerebroSQL

Oracle:

CREATE FLASHBACK ARCHIVE

CREATE FLASHBACK ARCHIVE [DEFAULT] flashback_archive
TABLESPACE tablespace
[flashback_archive_quota]
[ [NO] OPTIMIZE DATA ]
flashback_archive_retention
;

flashback_archive_quota::=
QUOTA integer { M | G | T | P | E }
flashback_archive_retention::=
RETENTION integer {YEAR | MONTH | DAY}

Example

CREATE FLASHBACK ARCHIVE DEFAULT test_archive1
TABLESPACE example
QUOTA 1 M
RETENTION 1 DAY;

CREATE FLASHBACK ARCHIVE test_archive2
TABLESPACE example
QUOTA 1 M
RETENTION 1 DAY;

ALTER FLASHBACK ARCHIVE test_archive1
MODIFY RETENTION 1 MONTH;

ALTER TABLE oe.customers
FLASHBACK ARCHIVE;

ALTER TABLE oe.orders
FLASHBACK ARCHIVE test_archive2;

DROP FLASHBACK ARCHIVE test_archive2;

bottom of page