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 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
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 |