My Oracle Support Banner

DataPump Import Fails With ORA-39083 ORA-00955 (Doc ID 2435025.1)

Last updated on MAY 18, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 18.9.0.0.0 [Release 12.1 to 18]
Information in this document applies to any platform.

Symptoms

NOTE: The user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

During the execution of DataPump import job the errors: ORA-39083 and ORA-00955 are hit when there are multiple UNIQUE constraints for a table (the order of the columns is different), for the same column:

ORA-39083: Object type CONSTRAINT:"<OWNER>"."<CONSTRAINT_NAME>" failed to create with error:
ORA-00955: name is already used by an existing object

The example below describes the scenario when the issue is hit:

 

Changes

 Database upgraded 12.1.0.2 and above.

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.