Last updated on MARCH 02, 2017
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.1 to 11.2]
Information in this document applies to any platform.
ORA-01452 may happen while creating a index or when rebuilding a index, even though there are no duplicate rows in the table.
alter index pin.I rebuild online nologging
ERROR at line 1:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Index is created using single quotes around the column names. Some times even OEM generated syntax may have quotes around the columns.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms