advertisements
_____________________________________________________________________________________________________________________
Impdp help=y shows FLASHBACK_SCN and FLASHBACK_TIME options in the list of parameters. But, when you try to import a dump with flashback_scn it says
ORA-39005: inconsistent arguments
ORA-39208: Parameter FLASHBACK_SCN is invalid for IMPORT jobs.
Something interesting!! J
. . .
. . .
FLASHBACK_SCN
SCN used to reset session snapshot.
FLASHBACK_TIME
Time used to find the closest corresponding SCN value.
impdp directory=exp_dir dumpfile=flash_test.dmp logfile=imp_flash_test.log flashback_scn=369458034
Import: Release 11.2.0.2.0 - Production on Mon May 14 03:51:43 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39005: inconsistent arguments
ORA-39208: Parameter FLASHBACK_SCN is invalid for IMPORT jobs.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment