Re: Data Pump over NETWORK_LINK
From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 21 Apr 2009 14:01:20 -0700
Message-ID: <bf46380904211401n55beba81t78cae5c21d8047a0_at_mail.gmail.com>
On Tue, Apr 21, 2009 at 11:44 AM, Mark W. Farnham <mwf_at_rsiz.com> wrote:
Date: Tue, 21 Apr 2009 14:01:20 -0700
Message-ID: <bf46380904211401n55beba81t78cae5c21d8047a0_at_mail.gmail.com>
On Tue, Apr 21, 2009 at 11:44 AM, Mark W. Farnham <mwf_at_rsiz.com> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 21 2009 - 16:01:20 CDT