Adpatch fails with: "The CREATE INDEX statement above failed because there is another index on the same columns" (Doc ID 1549195.1)

Last updated on FEBRUARY 17, 2014

Applies to:

Oracle Applications DBA - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to apply a patch, running an .odf file
the following error occurs.


Comparing objects in username <user> with ODF file $PRODUCT_TOP/patch/115/odf/<odf file>.odf
....
Start time for statement below is: date
ALTER TABLE <table_name> STORAGE (FREELISTS 4)

Statement executed.

*******************************************************
The table is missing the index <index_name>
or index <index_name> exists on another table.
Create it with the statement:


Start time for statement below is: date

CREATE INDEX <index_name> ON <table_name>
(<column_name>) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 )
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE


Statement executed.

The CREATE INDEX statement above failed because there is another index on the same columns.
Looking for the existing index on the same columns...

AD Worker error:
Unable to find existing index on the same columns

AD Worker error:
Unable to compare or correct tables or indexes or keys because of the error above

 
Note! The error can apply in any patch, for any table.


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms