My Oracle Support Banner

ORA-26097 During Datapump Import when going from 11.2.0.3 back to 11.2.0.1 (Doc ID 1465339.1)

Last updated on OCTOBER 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

1. A database upgraded from 11.2.0.1 to 11.2.0.3 successfully. Meantime DST timezone also changed from 11 to 14 after the upgrade.
2. We wanted to downgrade the upgraded database 11.2.0.3 back to 11.2.0.1. So we decided to go with datapump export/import option and took the export using the expdp utility of 11.2.0.1 version.
3. Export was a full database export.
4. Deleted the current 11.2.0.3 database completely.
5. Restored the database 11.2.0.1 using cold backup.
6. Dropped the main schema <SCHEMA> on the database.
7. Using the export dump file taken from 11.2.0.3, imported to 11.2.0.1 database for the dropped <SCHEMA>.
8. Import was going perfectly all tables were imported except one table "<TABLE>" on the schema.

During the import of this table got errors:

ORA-31693: Table data object "<SCHEMA>"."<TABLE>" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-26097: unsupported conversion for column SYS_NC0000400005$ (from type 58 to type 23)
During the import everything went fine except one table:

The <TABLE> involved was a nested table. 

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


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