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-22803: object type contains zero attributes

1 Answers  


ORA-06905: CMX: connect error

1 Answers  


ORA-01508: cannot create database; error in file 'string' at line string

1 Answers   Lionbridge,


PCC-00061: Error at line number, column number. PLS-number: string

1 Answers  


ORA-14454: attempt to reference temporary table in a referential integrity constraint

1 Answers  






ORA-12993: tablespace 'string' is offline, cannot drop column

1 Answers  


QSM-02056: correlated variable and outer join in mv

1 Answers  


TNS-00020: INTCTL: missing NAVIGATOR_DATA in TNSNAV.ORA

1 Answers  


RMAN-06105: duplicate qualifier found in LIST command: string

1 Answers  


ORA-24008: queue table string.string must be dropped first

1 Answers  


RMAN-06016: duplicate backup operand specified: string

1 Answers  


LPX-00003: duplicate entry in hash table

1 Answers  


Categories