REBUILD INDEX

[mike73]

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 ???

[sambavan]

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




Sam