Convert LONGs to LOBs

CREATE TABLE old_long_table(c1 NUMBER, c2 LONG);
INSERT INTO old_long_table VALUES (1, 'LONG data to convert to CLOB');

CREATE TABLE new_lob_table(c1 NUMBER, c2 clob);

-- Use TO_LOB function to convert LONG to LOB...
INSERT INTO new_lob_table
SELECT c1, TO_LOB(c2) FROM old_long_table;