Oracle | DBMS_FLASHBACK_ARCHIVE

Oracle DBMS_FLASHBACK_ARCHIVE_MIGRATE Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Utilities for exporting and importing a Flashback Archive using Transportable Tablespaces.

This package is not installed by default.

AUTHID CURRENT_USER

Dependencies

DBA_DATA_FILES	DBMS_METADATA	SYS_FBA_PARTITIONS
DBA_INDEXES	DBMS_OUTPUT	SYS_FBA_TRACKEDTABLES
DBA_LOBS	DBMS_SCHEDULER	SYS_FBA_TSFA
DBA_NESTED_TABLES	DBMS_SQL	SYS_FBA_USERS
DBA_OBJECTS	DBMS_STANDARD	TAB$
DBA_SEGMENTS	DBMS_SYSTEM	TRANSPORT_SET_VIOLATIONS
DBA_TABLES	DBMS_TTS	TS$
DBMS_ASSERT	PLITBLM	USER$
DBMS_DATAPUMP	SCN_TO_TIMESTAMP	V$DATABASE
DBMS_DB_VERSION	SMON_SCN_TIME	X$KSPPCV
DBMS_FLASHBACK_ARCHIVE	SYS_FBA_BARRIERSCN	X$KSPPI
DBMS_LOCK	SYS_FBA_FA	X$KSPPSV

Documented Yes: Packages and Types Reference

First Available 20c

Security Model Owned by SYS with no privileges granted

Source

The misspelling in the last two lines of PL/SQL warnings is Oracle's so please do not send an email asking for it to be corrected. This package is not installed by default.

SQL> @?/rdbms/admin/prvtfdams.plb Package created. No errors. SQL> @?/rdbms/admin/prvtfdamb.plb SP2-0810: Package Body created with compilation warnings Errors for PACKAGE BODY DBMS_FLASHBACK_ARCHIVE_MIGRATE: LINE/COL ERROR -------- ----------------------------------------------------------------- 163/3 PLW-06006: uncalled procedure "GET_FDA_MIG_TAB_NAME" is removed. 498/3 PLW-06006: uncalled procedure "TAMPER_PROOF_FDA_TABLES" is removed. 558/10 PLW-06009: procedure "CLEANUP_BACKUP_TABLES" OTHERS handler does not end in RAISE 903/19 PLW-06010: keyword "DURATION" used as a defined name 903/19 PLW-06010: keyword "PARAMETERS" used as a defined name 1510/16 PLW-05027: END statement identifier 'EACH_DATAFILE' should match label 'EACH_TABLESAPCE' at line 1500, column 9. 1536/7 PLW-05001: previous use of 'EACH_TABLESAPCE' (at line 1473) conflicts with this use

Subprograms

Exports a flashback archive dbms_flashback_archive_migrate.export( schema_owner IN VARCHAR2, fda_tables IN sys.dbms_sql.varchar2_table, tts IN VARCHAR2, data_pump_dir IN VARCHAR2, ignore_errors IN BOOLEAN);

TBD

EXPORT_ANALYZE

Analyzes and gathers statistics on a Flashback Archive export dbms_flashback_archive_migrateexport_analyze( schema_owner IN VARCHAR2, fda_tables IN sys.dbms_sql.varchar2_table, tts IN VARCHAR2);

TBD

IMPORT

Imports a flashback archive dbms_flashback_archive_migrate.import( schema_owner IN VARCHAR2, tts IN VARCHAR2, data_pump_dir IN VARCHAR2, tts_data_files IN sys.dbms_sql.varchar2_table);

TBD