Re: Data Pump over NETWORK_LINK

From: Jared Still <>
Date: Tue, 21 Apr 2009 14:01:20 -0700
Message-ID: <>

On Tue, Apr 21, 2009 at 11:44 AM, Mark W. Farnham <> 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

Received on Tue Apr 21 2009 - 16:01:20 CDT

Original text of this message