错误码 / Oracle Database
Oracle Database 错误码 ORA-43916
unable to determine collation for the column 原因:An attempt was made to create a virtual character column in a table, a character column in a table bas…
错误说明
unable to determine collation for the column
原因:An attempt was made to create a virtual character column in a table, a character column in a table based on a query (CREATE TABLE AS SELECT), or a character column in the key of a functional index. The expression on which the column definition was based did not have a derived collation to be used for the column, because of a collation conflict in one of its operators. In case of a virtual column, no collation was provided for the column through the data type declaration, either.
处理:Check the collation derivation rules in the Oracle Database documentation and apply the COLLATE operator in the defining expression as appropriate to resolve collation conflicts. If defining a virtual column, alternatively, specify a data type for the column to let the column inherit the collation from the table default, or specify the collation explicitly with the data type.