I have forgotten to mention that Oracle supports LONG to LOB migration. See: http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14249/adlob_long_lob.htm http://download.oracle.com/docs/cd/B10500_01/appdev.920/a96591/adl08lon.htm Regards, Łukasz Antoniak