RE: Copy long raw data from a remote database

From: David Boyd <davidb158_at_hotmail.com>
Date: Tue, 18 May 2004 09:07:54 -0400
Message-ID: <BAY2-F1094fDGCl9Fop000030bb@hotmail.com>

Shawn,

Thanks very much for your suggestion. Could be possible to share your script with me?

David

>From: "Shawn Ferris" <shawn_at_virtualsmf.net>
>Reply-To: oracle-l_at_freelists.org
>To: oracle-l_at_freelists.org
>CC: oracle-l_at_freelists.org
>Subject: RE: Copy long raw data from a remote database
>Date: Mon, 17 May 2004 22:59:24 -0600 (MDT)
>
>My suggestion is to unload the table into a flat file and use SQL*Loader
>with the direct option set. I have a quick and dirty Perl script I hacked
>together to unload a table given the name, or a select stmt. (It's not
>pretty.. maybe I'll clean it up a tad before hand)
>
>Using this script and SQL*Loader.. we un/load huge RAW/ CLOB tables in
>much less time than it would take exp/ imp. (From sybase, I unloaded a
>300k record table, a 2.5GB flat file, in about 45 minutes if I recall.. I
>think SQL*Load took about the same)
>
>This is 8i or better, yes? (I'm not sure how flexible the delimeters are
>in anything but 8.1.7 and better)
>
>Shawn
>SR. Database Admin
>Time Warner Telecom

---

Is your PC infected? Get a FREE online computer virus scan from McAfeeŽ Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue May 18 2004 - 09:00:00 CDT