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

ORA-27084: unable to get/set file status flags

1 Answers  


ORA-25330: PL/SQL associative arrays may not be used with AQ array operations

1 Answers  


ORA-36614: (XSLMS02) string attempted to retrieve a nonexistent user message. (Message number number)

1 Answers  


RMAN-08046: channel string: starting compressed full datafile backupset

1 Answers  


ORA-30454: summary contains STDDEV without corresponding SUM & COUNT

1 Answers  






TNS-00280: Max Avg Bytes/Sec : number

1 Answers  


ORA-17505: ksfdrsz:string Failed to resize file to size string blocks

1 Answers  


LPX-00284: namespace prefix to NULL URI is not allowed

1 Answers  


NID-00505: REVERT Revert failed change NO

1 Answers  


ORA-13433: GeoRaster metadata default RGB error

1 Answers  


ORA-23482: column string of "string"."string": object types not allowed.

1 Answers  


ORA-23371: column string unknown in table string

1 Answers  


Categories