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



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

NZE-28794: data type attribute did not initialize

1 Answers  


QSM-01024: materialized view, string, has unknown compile errors

1 Answers  


ORA-00264: no recovery required

1 Answers  


O2I-00125: Error writing to the INITFILE file

1 Answers  


ORA-32154: Anydata context not specified

1 Answers  






KUP-02006: script line too long

1 Answers  


CLSR-00508: Invalid message number number

1 Answers  


RMAN-06447: changed proxy copy available

1 Answers  


ORA-12071: definition query of "string"."string" is invalid for offline instantiation

1 Answers  


ORA-21703: cannot flush an object that is not modified

1 Answers  


TNS-00016: INTCTL: error while performing NS send command

1 Answers  


ORA-03200: the segment type specification is invalid

1 Answers  


Categories