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

MOSC Banner

Patch 6241631-11i.ATG_PF.H.RUP7 : Fails on icxwtab.odf

edited Jun 8, 2012 3:48AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 comment

Hi,
Issue: While applying patch 6241631-11i.ATG_PF.H.RUP7 Fails on icxwtab.odf

Cause:


CREATE UNIQUE INDEX ICX.ICX_TRANSACTIONS_U1 ON ICX.ICX_TRANSACTIONS
(TRANSACTION_ID) LOGGING STORAGE (INITIAL 4K NEXT 104K MINEXTENTS 1
MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE
10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS  TABLESPACE ICXX

Statement executed.

AD Worker error:
The index cannot be created as the table has duplicate keys.


Use the following SQL statement to identify the duplicate keys:

SELECT TRANSACTION_ID, count(*)
FROM ICX.ICX_TRANSACTIONS
GROUP BY TRANSACTION_ID
 HAVING count(*)>1

AD Worker error:
Unable to compare or correct tables or indexes or keys

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