(一)EXPDP
FLASHBACK_SCN=scn_value
FLASHBACK_SCN 与FLASHBACK_TIME冲突
使用此参数即使用表的闪回查询,它与其它闪回技术无关,如闪回数据库,回收站以及闪回归档。导出的数据将与指定的SCN一致。如果同时使用了network_link参数,此处指定的SCN为源库的SCN。
The FLASHBACK_SCN parameter pertains only to the Flashback Query capability of Oracle Database. It is not applicable to Flashback Database, Flashback Drop, or Flashback Data Archive.
Note: If you are on a logical standby system and using a network link to access the logical standby primary, then the FLASHBACK_SCN parameter is ignored because SCNs are selected by logical standby.
关于big SCN:
As of Oracle Database 12c release 2 (12.2), the SCN value can be a big SCN (8 bytes). You can also specify a big SCN when you create a dump file for an earlier version that does not support big SCNs because actual SCN values are not moved. See the following restrictions for more information about using big SCNs.
You cannot specify a big SCN for a network export or network import from a version that does not support big SCNs.
Example
$ expdp hr DIRECTORY=dpump_dir1 DUMPFILE=hr_scn.dmp FLASHBACK_SCN=384632
FLASHBACK_TIME="TO_TIMESTAMP(time-value)"
它实际上也是把时间转为最近的SCN来执行的:The export operation will be performed with data that is consistent with the SCN that most closely matches the specified time.
可以直接使用flashback_time=systimestamp,来表示当前时间(此处不用双引号)
如FLASHBACK_TIME="TO_TIMESTAMP('27-10-2012 13:16:00', 'DD-MM-YYYY HH24:MI:SS')"
(二)IMPDP
只能用于network_link选项,使用方式同上