ORA-02327: cannot create index on expression with datatype
string



ORA-02327: cannot create index on expression with datatype string..

Answer / guest

Cause: An attempt was made to create an index on a
non-indexable expression.

Action: Change the column datatype or do not create the
index on an expression whose datatype is one of VARRAY,
nested table, object, LOB, or REF.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-15022: parameter length 'string' is longer than string

1 Answers  


RMAN-10040: asynchronous support not detected, RMAN will run synchronously

1 Answers  


QSM-02013: SELECT list includes a RAW data type expression

1 Answers  


SQL*Loader-00105: Invalid data file name on command line

1 Answers  


ORA-29271: not connected

1 Answers  


RMAN-03017: recursion detected in stored script string

1 Answers  


ORA-13609: The specified task string must be executing to be cancelled or interrupted.

1 Answers  


ORA-06444: ssvpstev: Failed with unexpected error number.

1 Answers  


PLS-01711: A SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause

1 Answers  


KUP-03014: OCI error getting datetime fsprecision.

1 Answers  


PCC-02388: Arrays not allowed in FROM/WHERE clause of SELECT statement

1 Answers  


ORA-30111: no closing quote for value 'string'

1 Answers  


Categories