On Tue, Apr 21, 2009 at 11:44 AM, Mark W. Farnham <mwf@xxxxxxxx> wrote: > Do be advised that sqlplus copy will silently truncate any longs > transmitted > to the actual length or the long setting, whichever is shorter. > > The reasons mentioned are all very good reasons for converting LONG to LOB if at all possible. I've run into the same problems in impdp, as well as dbms_redefinition. LONGs are the ugly stepchild of the database. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist