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

PCC-02338: structure contains a nested struct or union

1 Answers  


PLS-01404: ANSI Identifiers can only consist of letters, digits, and the underscore character

1 Answers  


ORA-07451: slskstat: unable to obtain load information.

1 Answers  


ORA-29305: cannot point-in-time recover tablespace 'string'

1 Answers  


NID-00450: Succesfully changed database name and ID.

1 Answers  






ORA-06114: NETTCP: SID lookup failure

1 Answers  


ORA-07425: sdpri: error string in translating dump file location.

1 Answers  


RMAN-12001: could not open channel string

1 Answers  


ORA-13755: invalid "SQL Tuning Set" name

1 Answers  


RMAN-06015: error while looking up datafilecopy name: string

1 Answers  


QSM-01102: materialized view, string, requires join back to table, string, on column, string

1 Answers  


ORA-12067: empty refresh groups are not allowed

1 Answers  


Categories