Database Backup and Recovery (MOSC)

MOSC Banner

ORA-06512: "SYS.DBMS_FLASHBACK_ARCHIVE", line 86

edited Aug 8, 2018 5:01AM in Database Backup and Recovery (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center