1 Reply Latest reply: Sep 4, 2010 12:49 PM by Dude! RSS

    Flashback_scn and Flashback_time expdp parameter

      Does flashback needs to be enabled to use the expdp parameters flashback_time,flashback_scn?

        • 1. Re: Flashback_scn and Flashback_time expdp parameter
          The command 'ALTER DATABASE FLASHBACK ON' turns on flashback logging (archive of undo), normally stored in the Flash or Fast Recovery Area (FRA). It is used to enable the "Flashback Database" feature.

          Datapump does not use Flashback Database; it uses Flashback Query, which uses the UNDO tablespace. Since the Undo tablesapce works in a circular fashion, your ability to use Flashback Query by TIME or SCN will depend on its size and Undo retention policy.

          Edited by: Markus Waldorf on Sep 4, 2010 10:42 AM