DataPump Import (IMPDP) Fails With Error ORA-39083 Object Type INDEX_STATISTICS
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 07-May-2015**
DataPump import (IMPDP) fails 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-01408: such column list already indexed
- OR -
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type
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