16213660 AILED: file arhz.odf
Problem Summary
---------------------------------------------------
FAILED: file arhz.odf applying 16213660
Problem Description
---------------------------------------------------
CREATE UNIQUE INDEX AR.HZ_WORD_REPLACEMENTS_U1 ON AR.HZ_WORD_REPLACEMENTS
(TYPE, WORD_LIST_ID, CONDITION_ID, DELETE_FLAG, ORIGINAL_WORD,
USER_SPEC_COND_VALUE) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 )
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE
APPS_TS_SEED
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 TYPE, WORD_LIST_ID, CONDITION_ID, DELETE_FLAG, ORIGINAL_WORD, USER_SPEC_COND_VALUE, count(*)
FROM AR.HZ_WORD_REPLACEMENTS
GROUP BY TYPE, WORD_LIST_ID, CONDITION_ID, DELETE_FLAG, ORIGINAL_WORD, USER_SPEC_COND_VALUE
---------------------------------------------------
FAILED: file arhz.odf applying 16213660
Problem Description
---------------------------------------------------
CREATE UNIQUE INDEX AR.HZ_WORD_REPLACEMENTS_U1 ON AR.HZ_WORD_REPLACEMENTS
(TYPE, WORD_LIST_ID, CONDITION_ID, DELETE_FLAG, ORIGINAL_WORD,
USER_SPEC_COND_VALUE) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 )
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE
APPS_TS_SEED
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 TYPE, WORD_LIST_ID, CONDITION_ID, DELETE_FLAG, ORIGINAL_WORD, USER_SPEC_COND_VALUE, count(*)
FROM AR.HZ_WORD_REPLACEMENTS
GROUP BY TYPE, WORD_LIST_ID, CONDITION_ID, DELETE_FLAG, ORIGINAL_WORD, USER_SPEC_COND_VALUE
Tagged:
0