My Oracle Support Banner

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

Last updated on APRIL 17, 2023

Applies to:

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


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:



 Database upgraded and above.


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.