My Oracle Support Banner

DataPump Import (IMPDP) Fails With Error ORA-39083 Object Type INDEX_STATISTICS (Doc ID 1454880.1)

Last updated on DECEMBER 02, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata 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

DataPump import (IMPDP) fails with error:

ORA-39083: Object type INDEX_STATISTICS failed to create with error.


<Note 755253.1> was followed to rectify this. The import excluding indexes runs successfully.

The note says to run the impdp again with the include indexes after first excluding those. With the included indexes, this also generates errors and does not produce the results suggested by the note.

There are three errors types, two of them recur multiple times:

ORA-39083: Object type INDEX failed to create with error:
ORA-01408: such column list already indexed

- OR -

ORA-31684: Object type INDEX: already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type

 

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!

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