Oracle DBA, How To, Error, Cause and Action

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

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




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




Action: Recreate the cluster and remove the offending keywords.