Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

415769Jun 23 2008 — edited Oct 15 2009

Hi,
The tasks
TASK_GROUP_Extract_EmployeeDimension
Load into Position Dimension

getting the following error

484 SEVERE Sun Jun 22 11:55:55 PDT 2008 Failure detected while executing CREATE INDEX:W_EMPLOYEE_DS:W_EMPLOYEE_DS_U1.
Error Code: 12801.
Error Message: Error while execution : CREATE UNIQUE INDEX
W_EMPLOYEE_DS_U1
ON
W_EMPLOYEE_DS
(
INTEGRATION_ID ASC
,DATASOURCE_NUM_ID ASC
,SRC_EFF_FROM_DT ASC
)
NOLOGGING PARALLEL TABLESPACE qbiabidwidx
with error java.sql.SQLException: ORA-12801: error signaled in parallel query server P000
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

Any suggestion

Thanks
Ganesan

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2009

Added on Jun 23 2008

#business-intelligence-applications, #error, #index

5 comments

12,419 views