Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in
hash expression.



ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression...

Answer / guest

Cause: TO_DATE, USERENV and SYSDATE are not allowed in hash
expressions.

Action: Recreate the cluster and correct the error in hash
expression.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19323: Invalid url string

1 Answers  


ORA-09961: Unable to restore termination signal handler

1 Answers  


ORA-31630: a job name is required to attach a job for user string

1 Answers  


LFI-00122: Can only delete a file if we create it.

1 Answers  


ORA-00057: maximum number of temporary table locks exceeded

1 Answers  






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

1 Answers  


ORA-09272: remote os logon is not allowed

1 Answers  


LCD-00203: missing keyword [string]

1 Answers  


ORA-23291: Only base table columns may be renamed

1 Answers  


ORA-26717: SCN limit reached

1 Answers  


KUP-04041: error generating full file name for string in string

1 Answers  


ORA-02840: Open of log file by client failed

1 Answers  


Categories