1 Reply Latest reply: Aug 19, 2014 4:15 AM by Richard Harrison . RSS

    Importing flashback tables

    Ateet Mehta

      Hello All,


      We have created a flashback data archive in Oracle 11g R2 and enabled few of the tables to use this data archive for their changes.


      While we refresh our lower data environments (Development and UAT) using a production database, we are facing problem importing flashback tables. The metadata columns such as VERSIONS_STARTTIME, VERSIONS_ENDTIME, VERSIONS_OPERATION etc in the corresponding flashback tables (such as SYS_FBA_HIST_XXX for example) remains NULL and are not populated with correct metadata.


      Please let me know how to correctly import flashback tables such that these metadata columns do not remain NULL but populated with correct values.


      Thansk and Regards,