IMPDP FLASHBACK_SCN, FLASHBACK_TIME Shows in Parameter Help – Is it a bug?

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

impdp help=y
. . .
. . .

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.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google