Oracle FBDA

Flashback Data Archive

Flashback Data Archive

Check

SELECT * FROM dba_flashback_archive;

SELECT * FROM dba_flashback_archive_tables;

Disable

ALTER TABLE mySchema.myTable NO FLASHBACK ARCHIVE;

Do this to avoid ORA-55622: DML, ALTER and CREATE UNIQUE INDEX operations are not allowed on table...

Purge

To Purge all historical data from a Flashback Data Archive...

ALTER FLASHBACK ARCHIVE myFBDA PURGE ALL;

Bibliography



https://oracle-base.com/articles/11g/flashback-and-logminer-enhancements-11gr1#flashback_data_archivehttps://oracle-base.com/articles/12c/flashback-data-archive-fda-enhancements-12cr1
12.1https://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm#ADFNS01011 (Using Flashback Data Archive) Database Development Guidehttps://docs.oracle.com/database/121/SQLRF/statements_8016.htm#SQLRF20010 (DROP FLASHBACK ARCHIVE) Database SQL Language Reference
11.2https://docs.oracle.com/cd/E18283_01/server.112/e17110/statviews_3189.htm (DBA_FLASHBACK_ARCHIVE) Database Reference
My Oracle Supporthttps://support.oracle.comDrop User Fails With ORA-55622 Due to FBDA tables cleanup (Doc ID 2284724.1)Dropping User owning FBA enabled tables in 11G raises ORA-55622 (Doc ID 781563.1)