Yes, i agree, But unfortunately it was done like this earlier.

Selven can you please let me know if i can use

insert into table_name as select * from old_table;

to insert clob values from other table.

regards
anandkl