Kbase 40987: ORA-01408 error: ORA-01408 such column list already indexed
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Solution ID: P10987
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
ORACLE error 1408 see "ORACLE Error Messages and Codes Manual". (1252)
ORA-01408 error: ORA-01408 such column list already indexed.
CAUSE:
This behaviour is expected. Within Oracle, by implementing a Primary Key containing a column, the Oracle Server automatically creates an index on this column. This happens transparently to the user. If you then try to create another index on the same column, the server does not let you do this and generates the 1408 error. A single column may be indexed only once. Additional indexes may be created on the column if it is used as a portion of a concatenated index, that is, if the index consists of multiple columns.
FIX:
Add or remove fields/columns from the index definition