We can use the flashback parameter ( FLASHBACK_SCN or FLASHBACK_TIMESTAMP) in expdp to take a consistent backup of the table as of a specific point in time. Flashback method depends upon undo data. So if we are trying to take an export of the table with the flashback for which data is not available in UNDO, then export will fail.


Let’s insert some new data:

Now prepare PARFILE with FLASHBACK_SCN: ( Use the SCN value from step 1)

We are able to take expdp of the table with specific SCN.

Similarly, we can use FLASHBACK_TIME also:

Parfile with FLASHBACK_TIME: