Create Index CSF_PHONETIC_VALUES_U3 Fails As The Table Has Duplicate Keys
Last updated on MARCH 08, 2017
Applies to:
Oracle Field Service - Version 12.1.1 and laterInformation in this document applies to any platform.
***Checked for relevance on 11-Sep-2013***
Symptoms
When attempting to upgrade 12.1.1 the following error occurs:
The table is missing the index CSF_PHONETIC_VALUES_U3
or index CSF_PHONETIC_VALUES_U3 exists on another table.
Create it with the statement:
Start time for statement below is: Tue Jan 05 2010 16:11:05
CREATE UNIQUE INDEX CSF.CSF_PHONETIC_VALUES_U3 ON CSF.CSF_PHONETIC_VALUES
(LANGUAGE, PHONETIC, CODE) 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 LANGUAGE, PHONETIC, CODE, count(*)
FROM CSF.CSF_PHONETIC_VALUES
GROUP BY LANGUAGE, PHONETIC, CODE
HAVING count(*)>1
AD Worker error:
Unable to compare or correct tables or indexes or keys
because of the error above
or index CSF_PHONETIC_VALUES_U3 exists on another table.
Create it with the statement:
Start time for statement below is: Tue Jan 05 2010 16:11:05
CREATE UNIQUE INDEX CSF.CSF_PHONETIC_VALUES_U3 ON CSF.CSF_PHONETIC_VALUES
(LANGUAGE, PHONETIC, CODE) 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 LANGUAGE, PHONETIC, CODE, count(*)
FROM CSF.CSF_PHONETIC_VALUES
GROUP BY LANGUAGE, PHONETIC, CODE
HAVING count(*)>1
AD Worker error:
Unable to compare or correct tables or indexes or keys
because of the error above
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms