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

MOSC Banner

11.5.10.2 : Patch 12983438 failed while creating index

edited Dec 19, 2014 3:26AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered

Hello,


While applying patch 12983438 , we are facing issue with index creation mentioned in patch driver file.Further we have applied soultion as per Create Index Statement Above Failed Because There Is Another Index On The Same Columns. [ID 1130740.1]). but issue persist saying index already present on same column.


Log file is showing

File name : adwork001.log
-----------------------------------------
Start time for statement below is: Thu Dec 18 2014 18:10:02

CREATE INDEX PO.PO_ACCRUAL_WRITE_OFFS_N2 ON PO.PO_ACCRUAL_WRITE_OFFS_ALL
(INVOICE_ID, INVOICE_LINE_NUM) LOGGING STORAGE (INITIAL 4K NEXT 50K
MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELIST GROUPS 4
FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS

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