Patch 6678700 fails on frmxml.odf
Hi Everybody
Applying patch 6678700 fails on frmxml.odf with:
The table is missing the index FRM_USER_PUB_OPTIONS_UK1
or index FRM_USER_PUB_OPTIONS_UK1 exists on another table.
Create it with the statement:
Start time for statement below is: Fri May 17 2013 17:59:33
CREATE UNIQUE INDEX FRM.FRM_USER_PUB_OPTIONS_UK1 ON
FRM.FRM_USER_PUB_OPTIONS (REPORT_ID, USER_ID) LOGGING STORAGE (FREELIST
GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE
STATISTICS TABLESPACE APPS_TS_TX_IDX
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: