Oracle DBA, How To, Error, Cause and Action

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

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




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.