Error While Creating Index On OE_HEADERS_IFACE_ALL "ORA-01452: cannot CREATE UNIQUE INDEX ONT.OE_HEADERS_IFACE_ALL_U1 ON ONT.OE_HEADERS_IFACE_ALL ; duplicate keys found"
(Doc ID 1283190.1)
Last updated on DECEMBER 10, 2024
Applies to:
Oracle Order Management - Version 11.5.10.1 and laterInformation in this document applies to any platform.
Symptoms
When attempting to create Index on OE_HEADERS_IFACE_ALL table the following error occurs
Error
ERROR at line 1:
"ORA-01452: cannot CREATE UNIQUE INDEX ONT.OE_HEADERS_IFACE_ALL_U1 ON ONT.OE_HEADERS_IFACE_ALL ; duplicate keys found
"ORA-01452: cannot CREATE UNIQUE INDEX ONT.OE_HEADERS_IFACE_ALL_U1 ON ONT.OE_HEADERS_IFACE_ALL ; duplicate keys found
Steps
1. Go to SQL Developer
2. Connect the the database in which the Index need to be created
3. Execute below command
4. Notice the error
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 |
Cause |
Solution |
References |