Creation of INDEX "APPS"."CSI_ITEM_INSTANCES_F01" failed while applying Patch# 6671881
Hi All,
Below is the error.
Index CSI_ITEM_INSTANCES_F01 does not exist in APPS.
CREATE INDEX "APPS"."CSI_ITEM_INSTANCES_F01" ON "CSI"."CSI_ITEM_INSTANCES" (UPPER("SERIAL_NUMBER"))
PCTFREE 10 INITRANS 11 MAXTRANS 255
STORAGE(INITIAL 16384 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_IDX"
Start time for statement above is Tue Aug 27 01:37:04 UTC 2013
A Differnt index with same column name exists
AD Run Java Command is complete.
CREATE INDEX "APPS"."CSI_ITEM_INSTANCES_F01" ON "CSI"."CSI_ITEM_INSTANCES" (UPPER("SERIAL_NUMBER"))
PCTFREE 10 INITRANS 11 MAXTRANS 255
STORAGE(INITIAL 16384 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_IDX"
Start time for statement above is Tue Aug 27 01:37:04 UTC 2013
A Differnt index with same column name exists
AD Run Java Command is complete.
Tagged:
0