Oracle Solution for Error ora-29892

Solution for Oracle Error ORA-29892

ORA-29892: indextypes with array DML do not support the given data type

What triggered the Error:

The user specified a REF or a LONG datatype which is not supported in CREATE/ALTER INDEXTYPE WITH ARRAY DML (DATA_TYPE, VARRAY_TYPE).

What should we do to fix it:

Reissue the CREATE/ALTER INDEXTYPE statement without the REF or LONG datatype.