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

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

Question Posted / guest

1 Answers
2762 Views
I also Faced
E-Mail Answers

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

Answer / guest

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

Action: Recreate the cluster and remove the offending keywords.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12819: missing options in PARALLEL clause

1 Answers

RMAN-04005: error from target database: string

1 Answers

PLS-00429: unsupported feature with RETURNING clause

1 Answers

ORA-07565: sldext: $SEARCH failure

1 Answers

NNL-00276: Trace level is now number

1 Answers

ORA-02754: osnfsmmap: cannot change shared memory inheritence

1 Answers

NNL-00289: Scheduled cache flush to occur in string

1 Answers

ORA-26051: internal error parsing packed decimal format string

1 Answers

RMAN-06510: RMAN retention policy is set to recovery window of number days

1 Answers

ORA-04096: trigger 'string' has a WHEN clause which is too large, limit 2K

1 Answers

CLSR-01009: database management module failed to start

1 Answers

AMD-00106: parent string "string" must be removed before child string "string" can be removed

1 Answers

For more Oracle Errors Interview Questions Click Here