Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-01408

such column list already indexed

Cause

A CREATE INDEX statement specified a column that was already indexed. A single column may be indexed only once. Additional indexes may be created on the column if it was used as a portion of a concatenated index, that was, if the index consists of multiple columns.


Action

Do not attempt to re-index the column, as it is unnecessary. To create a concatenated key, specify one or more additional columns in the CREATE INDEX statement.