SQL>
SQL> create table long_table
2 ( id int primary key,
3 data long
4 )
5 /
Table created.
SQL> create table clob_table as select id, to_lob(data) data from long_table;
Table created.
SQL>
SQL> insert into clob_table select id, to_lob(data) from long_table;
0 rows created.
SQL>
SQL> begin
2 insert into clob_table select id, to_lob(data) from long_table;
3 end;
4 /
PL/SQL procedure successfully completed.
SQL>
SQL> drop table clob_table;
Table dropped.
SQL>
SQL> drop table long_table;
Table dropped.