Database Error Messages

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

ORA-43921

invalid collation for cluster column

Cause

An attempt was made to create an index cluster in which one of the key columns had an unsupported declared collation or an attempt was made to create a hash cluster in which a key column with SORT clause had an unsupported declared collation. Only the collations BINARY, USING_NLS_COMP, USING_NLS_SORT, USING_NLS_SORT_CS, USING_NLS_SORT_VAR1, and USING_NLS_SORT_VAR1_CS are supported for character columns in index clusters and for sorted character columns of hash clusters.


Action

Use one of the supported collations for the offending column.