错误码 / Oracle Database
Oracle Database 错误码 ORA-43930
A query issued from a pre-12.2 database references a column with an unsupported collation. 原因:A table or view column with a declared collation other t…
错误说明
A query issued from a pre-12.2 database references a column with an unsupported collation.
原因: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.
处理: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.