11i.ATG_PF.H.RUP7-6241631- duplicate index error how to proceed?
Applying patch 11i.ATG_PF.H.RUP7-6241631 and I have a worker in error trying to create an existing index.
Should I skip this worker with "adctrl" option 8 or drop the index and restart the worker?
Should I skip this worker with "adctrl" option 8 or drop the index and restart the worker?
Error is:
Start time for statement below is: Mon Mar 18 2013 12:43:52CREATE UNIQUE INDEX ICX.ICX_TRANSACTIONS_U1 ON ICX.ICX_TRANSACTIONS
(TRANSACTION_ID) LOGGING 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
Tagged:
0