Re: Data Pump over NETWORK_LINK

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: mwf@xxxxxxxx
  • Date: Tue, 21 Apr 2009 14:01:20 -0700

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

Other related posts: