DataPump Import Fails With ORA-39083 ORA-00955
(Doc ID 2435025.1)
Last updated on FEBRUARY 24, 2022
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206.0 [Release 12.1 to 18]
Information in this document applies to any platform.
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-00955: name is already used by an existing object
The example below describes the scenario when the issue is hit:
Database upgraded 220.127.116.11 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