Patch 6770055.11i fails on file jtftasn.odf CREATE INDEX JTF.JTF_TASK_ASSIGNMENTS_N5 another index
Hello,
Patch 6770055.11i fails on file jtftasn.odf CREATE INDEX JTF.JTF_TASK_ASSIGNMENTS_N5 another index on the same columns.
The table is missing the index JTF_TASK_ASSIGNMENTS_N5
or index JTF_TASK_ASSIGNMENTS_N5 exists on another table.
Create it with the statement:
Start time for statement below is: Sun May 20 2012 12:16:53
CREATE INDEX JTF.JTF_TASK_ASSIGNMENTS_N5 ON JTF.JTF_TASK_ASSIGNMENTS
(RESOURCE_ID, RESOURCE_TYPE_CODE, ASSIGNEE_ROLE) LOGGING PCTFREE 10
INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS PARALLEL TABLESPACE
APPS_TS_TX_IDX
Statement executed.
The CREATE INDEX statement above failed because there is
another index on the same columns.