can someone tell me why I go this message when I tried to rebuild an index ????
Ora-02327: cannot create index on espression with datatype ADT
Can someone tell me how to fix it ???
02327, 00000, "cannot create index on expression with datatype %s"
// *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.
//02328, 00000, "REF column cannot be specified on VALUE ADT"
// *Cause: attempt to create REF column of VALUE ADT
// *Action: remove REF specifier from column specification
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width