My Oracle Support Banner

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 MAY 17, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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 "<USER>"."SYS_EXPORT_SCHEMA_01": /********@<DB NAME> parfile=<FILE NAME>.par dumpfile=<FILE NAME>.dmp logfile=<FILE NAME>.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 "<OWNER>"."<TABLE NAME>":"<PART NAME>" 5.218 KB 3 rows
ORA-31693: Table data object "<OWNER>"."<TABLE NAME>":"<PART NAME>" 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 "<OWNER>"."<TABLE NAME>" 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 "<OWNER>"."<TABLE NAME>" 0 KB 0 rows
Master table "<OWNER>"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for <USER>.SYS_EXPORT_SCHEMA_01 is:
<FILE NAME>.dmp
Job "<USER>"."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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.