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

CLSR-01004: Failed to mount database

1 Answers  


LPX-00401: invalid QName in the XSL file

1 Answers  


RMAN-10006: error running SQL statement: string

1 Answers  


KUP-03002: end position (number) <= start position (number) for field: string

1 Answers  


ORA-30197: reserved for future use

1 Answers  






ORA-15184: ASMLIB error could not be determined [string] [string]

1 Answers  


LSX-00210: value "~1S" out of range for type "~2S"

1 Answers  


ORA-14128: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION

1 Answers  


ORA-08465: input mask contains more than 32 characters

1 Answers  


ORA-06580: Hash Join ran out of memory while keeping large rows in memory

1 Answers  


ORA-31445: invalid lock handle while acquiring lock on string

1 Answers  


NNC-00411: invalid default domain name "string"

1 Answers  


Categories