Database Error Messages

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

OCI-12746

unrecognized collation name "string"

Cause

The name of the collation that you specified was not recognized by the Oracle Database, because the name was misspelled, or the collation was user-defined but not installed in the Oracle Home of the database instance, or because the directory specified in the ORA_NLS10 environment setting, either explicitly or defaulting to $ORACLE_HOME/nls/data (%ORACLE_HOME%\nls\data on Microsoft Windows), did not contain valid NLS data files.


Action

Specify a valid collation name or fix your database software configuration.