RE: Data Pump over NETWORK_LINK

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Wed, 22 Apr 2009 09:59:32 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F15207E6B_at_AAPQMAILBX02V.proque.st>

"Do as I say, not as I do..." :)

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Goulet, Richard Sent: Wednesday, April 22, 2009 9:10 AM
To: jkstill_at_gmail.com; mwf_at_rsiz.com Cc: oracle-l_at_freelists.org
Subject: RE: Data Pump over NETWORK_LINK

Jared,

    How true and how long has Oracle been telling us to stop using them? Course it would help is they took their own medicine.

Dick Goulet
Senior Oracle DBA
PAREXEL International

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Tuesday, April 21, 2009 5:01 PM
To: mwf_at_rsiz.com
Cc: oracle-l_at_freelists.org
Subject: Re: Data Pump over NETWORK_LINK On Tue, Apr 21, 2009 at 11:44 AM, Mark W. Farnham <mwf_at_rsiz.com<mailto: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-l

Received on Wed Apr 22 2009 - 08:59:32 CDT