March 17, 2017 / doganay
expdp FLASHBACK_TIME
(full) year must be between -4713 and +9999 and not be 0, bad flashback time, expdp, FLASHBACK_TIME, invalid argument value, LRM-00112, LRM-00116, missing right parenthesis, multiple values not allowed for parameter 'flashback_time', ORA-00907, ORA-01841, ORA-39001, ORA-39150, syntax error at ')' following 'YYYY/MM/DD HH24:', TO_TIMESTAMP
$ 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 ...
Filed under ORACLE
Leave a comment