top of page
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