unable to create the collation key

Solution ID:ORA-12742

Type: Oracle

Cause

The character argument of a collation-sensitive operator was too long or it had too many decomposable characters to create a collation key for it in the available buffer space.

Actions

Shorten the argument value or, if using a UCA-based collation, increase the ratio of characters with short or no Unicode decomposition to characters with long Unicode decomposition in the value.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


http://docs.oracle.com/cd/E16655_01/server.121/e17209/functions120.htm


http://docs.oracle.com/cd/E16655_01/server.121/e17750/ch5lingsort.htm


https://community.oracle.com/message/11332224


Browse all solutions to database errors from Oracle, MS SQL, or MySQL