Data Pump Export Fails With Errors ORA-39127, ORA-20240, ORA-6512 (Doc ID 1643003.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

DataPump export (expdp) reports errors like below:

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39127: unexpected error from call to local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA('BM_CHEM_SIM_IDX','IDBS_EWB_DW','MOLECULESIMSEARCHTYPE','C$EWBCHX',11.02.00.00.00,newblock)
ORA-20240: Import and Export of ChemXtra indexes is not supported. You will need to rebuild this index manually in the destination schema.
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 270
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 8365
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX
ORA-39127: unexpected error from call to local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA('MOL_STRUC_SIM_IDX3','IDBS_EWB_DW','MOLECULESIMSEARCHTYPE','C$EWBCHX',11.02.00.00.00,newblock)
ORA-20240: Import and Export of ChemXtra indexes is not supported. You will need to rebuild this index manually in the destination schema.
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 270
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 8365
ORA-39127: unexpected error from call to local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA('MOLECULE_STRUCTURE_SEARCH_IDX','IDBS_EWB_DW','MOLECULESTRUCTSEARCHTYPE','C$EWBCHX',11.02.00.00.00,newblock)
ORA-20240: Import and Export of ChemXtra indexes is not supported. You will need to rebuild this index manually in the destination schema.
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 270
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 8365

 

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