Oracle DBA, How To, Error, Cause and Action

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

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


Cause:


SYSDATE, UID, USER, ROWNUM, or LEVEL are not allowed in hash expressions.



Action:


Recreate the cluster and remove the offending keywords.

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)