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 19.18.0.0.0 and later
Information in this document applies to any platform.

Symptoms

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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