When exporting data we can also use Data Pump with flashback to make a point-in-time export by using the parameter
FLASHBACK_TIME assigning a timestamp to it, or
FLASHBACK_SCN to assign a specific SCN, if using this option, the database will look for the SCN that most closely matches the specified time, and this SCN will be used to enable the Flashback utility and the export operation will be performed with the data that is consistent up to this SCN. In this scenario, we will export the data of the table
EMPLOYEE from the schema
TEST up to 30 minutes ago shown as follows:
$ expdp directory=datapump dumpfile=employee_flashback_06192013.dmp flashback_time="to_timestamp('19-06-2013 14:30:00', 'dd-m m-yyyy hh24:mi:ss')"
Some restrictions ...