Oracle Error ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.

Oracle Error Message

ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.

Reason for the Error

TO_DATE, USERENV and SYSDATE are not allowed in hash expressions.

Solution

Recreate the cluster and correct the error in hash expression.