How can you migrate from a LONG to a LOB data type for a column?
Use the DBMS_MANAGE_LOB.MIGRATE procedure
Use the UTL_MANAGE_LOB.MIGRATE procedure.
Use the ALTER TABLE command
You cannot migrate from a LONG to a LOB date type for a column