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

RMAN-20505: create datafile during recovery

1 Answers  


LSX-00176: circular reference detected in schema component named "~S"

1 Answers  


PCC-01515: FIPS warning: Undeclared host variable "string" at line number in file string

1 Answers  


ORA-26534: collision: tranID number ignored and purged

1 Answers  


NNL-00502: Shows, sets, or cancels when the server next dumps its statistic counters

1 Answers  


NZE-28855: Unsupported SSL operation

1 Answers  


ORA-39071: Value for string filter is badly formed.

1 Answers  


PCB-00603: An EXEC TOOLS MESSAGE host variable is not a character type

1 Answers  


PLS-00257: illegal use of EXTERNAL clause in a TYPE or PACKAGE specification

1 Answers  


ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

1 Answers  


TNS-12558: TNS:protocol adapter not loaded

1 Answers  


RMAN-06468: Invalid Data Block Address: number

1 Answers  


Categories