Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export error ORA-08186

user3636719Apr 18 2013 — edited Apr 19 2013

Hello gurus,

Please help me with below export.

Here is the para file of export.

Cat expdp.par
tables=USER1.TMP_01,USER1.TMP_02,USER1.TEMP_03
directory=DATAPUMP
dumpfile=expdp_%u.dmp
logfile=expdp.log
JOB_NAME=expdp_job
FILESIZE=4G
VERSION=LATEST
FLASHBACK_SCN=61281521

select current_scn from v$database;

61292504

Here is my export log

expdp "'/ as sysdba'" parfile=expdp_dsatrn.par

Export: Release 11.2.0.2.0 - Production on Thu Apr 18 12:17:11 2013

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"." EXPDP_JOB":  "/******** AS SYSDBA" parfile=expdp.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 384 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-31693: Table data object "USER1"."TMP_01" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-08186: invalid timestamp specified
ORA-06512: at "SYS.TIMESTAMP_TO_SCN", line 1
ORA-31693: Table data object "USER1"."TMP_02" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-08186: invalid timestamp specified
ORA-06512: at "SYS.TIMESTAMP_TO_SCN", line 1
. . exported "USER1"."TEM_03"                  6.648 KB       0 rows
Master table "SYS"." EXPDP_JOB" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS. EXPDP_JOB is:
  /db1/rdbm7/expdp_01.dmp
Job "SYS"." EXPDP_JOB" completed with 2 error(s) at 12:17:41

According to below suggestion, I increased my undo from 2 Gig to 8Gig, still no result.

I tried blow also got error as followed

flashback_time=\"TO_TIMESTAMP \(TO_CHAR \(SYSDATE, \'YYYY-MM-DD HH24:MI:SS\'\), \'YYYY-MM-DD HH24:MI:SS\'\)\"

LRM-00112: multiple values not allowed for parameter 'flashback_time'
LRM-00113: error when processing file 'expdp_dsatrn.par'


and

FLASHBACK_TIME=TO_TIMESTAMP(TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS')

LRM-00116: syntax error at ')' following 'YYYY-MM-DD HH24:'
LRM-00113: error when processing file 'expdp.par'

Edited by: user3636719 on Apr 18, 2013 10:15 AM

Edited by: user3636719 on Apr 18, 2013 12:36 PM