In Oracle8i a LONG column could be converted to a LOB using the TO_LOB() function.
One of the restrictions on that use was it could not be used to convert a column in an existing table , only during the creation of a new table.
In Oracle9i this conversion is possible using the ALTER TABLE with MODIFY syntax:
Column content is currently a LONG
ALTER TABLE documents MODIFY (content CLOB);
Column content is currently a LONG RAW
ALTER TABLE executables MODIFY (content BLOB);
This syntax can only be used for the conversion of LONG and LONG RAW columns.
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it