My Oracle Support Banner

DRG-10507: DUPLICATE INDEX NAME From Parallel Impdp When Different Users Own Oracle Text Indexes with the Same Name (Doc ID 2970015.1)

Last updated on OCTOBER 06, 2023

Applies to:

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


Parallel datapump import (impdp parallel=X) results in DRG-10507 if importing several users who own Text Index with the same name.

For example, let's say the export dump contains these 2 user:

- TEXTUSER1 owns table QUICK and text index QUICK_TEXT
- TEXTUSER2 owns table QUICK and text index QUICK_TEXT

When importing such export dump using parallel=2, below error occurs and one of the indexes is not created.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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