Default: There is no default
Purpose
Syntax and Description
FLASHBACK_SCN=scn_number
The import operation is performed with data that is consistent up to the specified scn_number
.
If you are on a logical standby system, then the FLASHBACK_SCN
parameter is ignored because SCNs are selected by logical standby. See Oracle Data Guard Concepts and Administration for information about logical standby databases.
Restrictions
The FLASHBACK_SCN
parameter is valid only when the NETWORK_LINK
parameter is also specified.
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.
FLASHBACK_SCN
and FLASHBACK_TIME
are mutually exclusive.
Example
The following is an example of using the FLASHBACK_SCN
parameter.
> impdp hr DIRECTORY=dpump_dir1 FLASHBACK_SCN=123456 NETWORK_LINK=source_database_link
The source_database_link
in this example would be replaced with the name of a source database from which you were importing data.