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 to this kind of operation are:
FLASHBACK_TIMEandFLASHBACK_SCNare mutually exclusive.The
FLASHBACK_TIMEparameter pertains only to the flashback query capability of Oracle Database. It is not applicable to Flashback Database, Flashback...