Import raises DRG-10507 error on non-existent domain index (Doc ID 2532194.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

An import is raising errors on some domain indexes:

ORA-39083: Object type INDEX failed to create with error:
ORA-20000: Oracle Text error:
DRG-52204: error while registering index
DRG-10507: duplicate index name: <index name>, owner: <index owner>
Failing sql is:
BEGIN
ctxsys.driimp.create_index('<index name>','<index owner>',USER,
'','1','DESCRIPTION','1','1024','0','8130','1',
'LANGCODE',NULL, NULL, 0,'Y',NULL, NULL, NULL, NULL, NULL);

but an index with the same name does not exist in the database.

Changes

Cause

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