ORA-43916
unable to determine collation for the column
Cause
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.
Action
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.
ORA-43916
unable to determine collation for the column
Cause
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.
Action
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.
ORA-43916
unable to determine collation for the column
Cause
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.
Action
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.