RE: Copy long raw data from a remote database

From: Shawn Ferris <shawn_at_virtualsmf.net>
Date: Mon, 17 May 2004 22:59:24 -0600 (MDT)
Message-ID: <7836.168.215.22.23.1084856364.squirrel@mail.virtualsmf.net>

> Yes. Exp/imp works for long raw data. There are 33 fields in the remote
> table. We want to replicate only 4 fields, including long raw field. We
> want replicating the updates daily. I'm trying to get a best way to do
> this.

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

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 Mon May 17 2004 - 23:48:08 CDT