ORA-01448: index must be dropped before changing to desired type

oracle

ORA-01448: index must be dropped before changing to desired type
Cause: 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.
Action: Drop all indexes referencing the column before changing its datatype to LONG.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/