Oracle | DBMS_FLASHBACK_ARCHIVE

Oracle DBMS_FLASHBACK_ARCHIVE_MIGRATE Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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

This package is not installed by default.

AUTHID CURRENT_USER

Dependencies

DBMS_SQL

Documented Yes: Packages and Types Reference

First Available 20c

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtfdams.plb

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 (new 21c)

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 (new 21c)

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

TBD