Database Error Messages

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

OCI-43930

A query issued from a pre-12.2 database references a column with an unsupported collation.

Cause

A table or view column with a declared collation other than USING_NLS_COMP was referenced in a distributed query that originated in an Oracle Database with the release number lower than 12.2. Such references are not allowed.


Action

In the remote database that reported this error, create a view corresponding to the subquery that was executed in that database and make sure that all columns of this view have the collation USING_NLS_COMP. Use the COLLATE operator if necessary. In the original query, replace the subquery with a reference to the view.