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 APRIL 04, 2025
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
....
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
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
| Symptoms |
| Cause |
| Solution |