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 22.214.171.124 to 126.96.36.199.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 188.8.131.52 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