I have a table with a CLOB in it (plus some normal fields, couple of decimals, some ints, some varchar2(x)).
I am told that "Insert into table (select....))" is not the fastest way to load a CLOB.
Does anyone know the fastest way to move a CLOB over (with the other fields)?
Efficiencey is the name of the game here. Source and Target tables are both in ORACLE instances.