RE: Copy long raw data from a remote database
- From: "David Boyd" <davidb158@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 18 May 2004 09:07:54 -0400
Shawn,
Thanks very much for your suggestion. Could be possible to share your
script with me?
David
>From: "Shawn Ferris" <shawn@xxxxxxxxxxxxxx>
>Reply-To: oracle-l@xxxxxxxxxxxxx
>To: oracle-l@xxxxxxxxxxxxx
>CC: oracle-l@xxxxxxxxxxxxx
>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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
