ORA-31693 ORA-29913 ORA-29400 and ORA-39786 Errors During 11.1.0.7 Data Pump Import of SQL Tuning Sets (STS) From 10.2
(Doc ID 1285889.1)
Last updated on APRIL 03, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.1 [Release 11.1 to 11.2]Information in this document applies to any platform.
Symptoms
Successfully exported SQL Tuning Sets (STS) from 10.2.0.4 and trying to import into an 11.1.0.7 RDBMS using Data Pump, the following error is encountered:
EXAMPLE:
ORA-31693: Table data object "<SCHEMA_NAME>"."<STS_TABLE_NAME>" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
ORA-39786: Number of columns does not match between export and import databases
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
ORA-39786: Number of columns does not match between export and import databases
Changes
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 |