My Oracle Support Banner

R12:PA: CREATE UNIQUE INDEX "PA"."PA_PROJECTS_U3" ORA-1452 (Doc ID 2572154.1)

Last updated on JULY 08, 2020

Applies to:

Oracle Project Foundation - Version 12.0.4 and later
Information in this document applies to any platform.

Goal

While running post DMU (Database Migration Assistant for Unicode)  steps below index creation failed with ORA-1452 error.

SQL text is CREATE UNIQUE INDEX "PA"."PA_PROJECTS_U3" ON "PA"."PA_PROJECTS_ALL" ("NAME")
PCTFREE 5 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "APPS_TS_TX_IDX"
NOLOGGING ;
Connection ID is 6. Connection session ID is 822, serial number is 47764.
Exception error code is 1452.
Exception call stack is
java.sql.SQLException: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.