SQL>
SQL>
SQL> CREATE TABLE myTable (
2 id NUMBER,
3 text LONG);
Table created.
SQL>
SQL> INSERT INTO myTable (id, text)VALUES (1, 'Change the column from LONG to CLOB');
1 row created.
SQL>
SQL> ALTER TABLE myTable
2 MODIFY text CLOB;
Table altered.
SQL>
SQL> DESC myTable
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
TEXT CLOB
SQL>
SQL> drop table myTable;
Table dropped.