On Datapump Import We Are Getting Error ORA-26017. But There are No Global Indexes On That Table. (Doc ID 2127650.1)

Last updated on APRIL 15, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

On Datapump import we are getting error ORA-26017 on the table import. But there is no global indexes on that table:

ORA-31693: Table data object "FDM_DBA"."FDM_FAC_SCHEMATIC_RAW":"P_DIV_10" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-26017: global indexes not allowed for direct path load of table partition "FDM_DBA"."FDM_FAC_SCHEMATIC_RAW"

 

Select index_name, index_type, table_owner, table_name from dba_indexes where table_name='FDM_FAC_SCHEMATIC_RAW';

INDEX_NAME                     INDEX_TYPE
------------------------------ ---------------------------
TABLE_OWNER                   TABLE_NAME
------------------------------ ------------------------------
FDM_FAC_SCHEMATIC_RAW_PK NORMAL
FDM_DBA                            FDM_FAC_SCHEMATIC_RAW

Cause

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