ORA-01452 On Table while rebuilding index
(Doc ID 1629887.1)
Last updated on OCTOBER 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
ORA-01452 may happen while creating a index or when rebuilding a index, even though there are no duplicate rows in the table.
Verifying existance of duplicate rows using script in 332494.1, but you may not find any duplicate rows.
alter index pin.I rebuild online nologging
*
ERROR at line 1:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Changes
Index is created using single quotes around the column names. Some times even OEM generated syntax may have quotes around the columns.
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 |