Skip to content
March 17, 2017 / doganay

expdp FLASHBACK_TIME

$ expdp FLASHBACK_TIME=TO_TIMESTAMP('2017/03/01 14:41:01', 'YYYY/MM/DD HH24:MI:SS') schemas=owner1 directory=tmpdir dumpfile=owner1.dmp

-bash: syntax error near unexpected token `('

$ expdp FLASHBACK_TIME="TO_TIMESTAMP('2017/03/01 14:41:01', 'YYYY/MM/DD HH24:MI:SS')" schemas=owner1 directory=tmpdir dumpfile=owner1.dmp

LRM-00116: syntax error at ')' following 'YYYY/MM/DD HH24:'

$ expdp FLASHBACK_TIME=\"TO_TIMESTAMP\('2017/03/0114:41:01', 'YYYY/MM/DDHH24:MI:SS'\)\" schemas=owner1 directory=tmpdir dumpfile=owner1.dmp

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning option
ORA-39001: invalid argument value
ORA-39150: bad flashback time
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
ORA-00907: missing right parenthesis

$ expdp FLASHBACK_TIME="2017/03/17 15:34:01" schemas=owner1 directory=tmpdir dumpfile=owner1.dmp

LRM-00112: multiple values not allowed for parameter 'flashback_time'


Solution:

$ expdp FLASHBACK_TIME="2017/03/1715:34:01" schemas=doganay directory=tmpdir dumpfile=owner1.dmp

Export: Release 11.2.0.4.0 - Production on Fri Mar 17 15:35:22 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning option
Starting "SYS"."SYS_EXPORT_SCHEMA_01":  /******** AS SYSDBA FLASHBACK_TIME=2017/03/1715:34:01 schemas=owner1 directory=tmpdir dumpfile=owner1.dmp 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1.125 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
...

Leave a comment