Oracle DBA, How To, Error, Cause and Action

ORA-12742: unable to create the collation key

ORA-12742: unable to create the collation key


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.



Action:


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.

No comments:

Post a Comment

Thanks for your comment.