Oracle Error ORA-02471: SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expre\ssion.

Oracle Error Message

ORA-02471: SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expre\ssion.

Reason for the Error

SYSDATE, UID, USER, ROWNUM, or LEVEL are not allowed in hash expression\s.

Solution

Recreate the cluster and remove the offending keywords.