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

TNS-01095: %s * string * string * number

1 Answers  


ORA-28183: proper authentication not provided by proxy

1 Answers  


PROC-00018: The value size passed is too large

1 Answers  


NZE-29108: Cannot initialize random object.

1 Answers  


ORA-25509: operation on "string"."string".string not allowed

1 Answers  


ORA-26057: Conversion is not necessary for this direct path stream.

1 Answers  


ORA-26690: datatype not supported at non-Oracle system

1 Answers  


ORA-32403: cannot use new values from mv log on "string"."string"

1 Answers  


ORA-12007: materialized view reuse parameters are inconsistent

1 Answers  


LRM-00123: invalid character number found in the input file

1 Answers   BSNL, IBM,


ORA-29887: cannot support row movement if domain index defined on table

1 Answers  


ORA-09322: slpdtb: unable to convert packed decimal to binary

1 Answers  


Categories