Oracle Error Codes

index must be dropped before changing to desired type

An ALTER TABLE MODIFY statement attempted to change an indexed character column to a LONG column. Columns with the datatype LONG may not be indexed, so the index must be dropped before the modification.

How to Solve :

Drop all indexes referencing the column before changing its datatype to LONG.