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.

No comments:

Post a Comment

Thanks for your comment.