ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Utilities for exporting and importing a Flashback Archive using Transportable Tablespaces.
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
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);
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);