Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Patch 6770055.11i fails on file jtftasn.odf CREATE INDEX JTF.JTF_TASK_ASSIGNMENTS_N5 another index

edited Jun 19, 2012 9:42PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 comments

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center