Datapump Export Fails with ORA-31693, ORA-2354, ORA-8186, ORA-6512 Errors for Tables with Timestamp and Timezone Columns Using FLASHBACK_SCN Parameter (Doc ID 2090895.1)

Last updated on DECEMBER 28, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

The Datapump Export on 12.1.0.2 fails with the following errors:

Export: Release 12.1.0.2.0 - Production on Wed Nov 11 07:50:41 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "CEPM"."SYS_EXPORT_SCHEMA_01": /********@cpm10 parfile=/opt/CSCOcpm/bin/sync_exp.par dumpfile=cpmsync_f3bc3e20-888b-11e5-b2da-005056103001.dmp logfile=exp_f3bc3e20-888b-11e5-b2da-005056103001.log FLASHBACK_SCN=2330536
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1.743 GB
Processing object type SCHEMA_EXPORT/TABLE/TABLE

. . exported "CEPM"."EDF_DB_LOG":"SYS_P542" 5.218 KB 3 rows
ORA-31693: Table data object "CEPM"."EDF_EP_MASTER":"SYS_P88" 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 "CEPM"."EDF_GUEST_LANGUAGE_BUNDLE" 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 "CEPM"."UPSUSER_USERTYPEATTRVALUES" 0 KB 0 rows
. . exported "CEPM"."UPSWORKFLOW_ROLES" 0 KB 0 rows
. . exported "CEPM"."UPSWORKFLOW_SETTINGS" 0 KB 0 rows
. . exported "CEPM"."WCS_SSO_TOKEN" 0 KB 0 rows
Master table "CEPM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for CEPM.SYS_EXPORT_SCHEMA_01 is:
/opt/oracle/base/admin/cpm10/dpdump/cpmsync_f3bc3e20-888b-11e5-b2da-005056103001.dmp
Job "CEPM"."SYS_EXPORT_SCHEMA_01" completed with 130 error(s) at Wed Nov 11 07:52:11 2015 elapsed 0 00:01:21 

Changes

The database is copied from a machine on IST time zone to PST time zone and then the export is done on the PST time zone machine.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms