ORA-06512: "SYS.DBMS_FLASHBACK_ARCHIVE", line 86
Dear all
We try to use the Flashback Data Archive (FDA) Enhancements in Oracle Database 12c Release 1 (12.1).
we have executed the following procedure with success.
BEGIN
DBMS_FLASHBACK_ARCHIVE.create_temp_history_table(
owner_name1 => 'TEST',
table_name1 => 'TAB1');
END;
/
INSERT /*+ APPEND */ INTO temp_history
SELECT * FROM SYS_FBA_HIST_77672;
we used the tool exp for the table TAB1 and temp_history.
we used the tool imp for import these tables in the new schema FDA.
we enabled the table TAB1 with the flasback archive and when try to import the temp_history in the new schema , we have the following error.