RE: Copy long raw data from a remote database

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 17 May 2004 13:20:45 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F87856@irvmbxw02>

Why can't you use export / import?=20

-----Original Message-----

David Boyd

We want to replicate a table that contains a long raw field from a remote=20
database. All of Oracle replication methods don't apply to long raw data. =20
So we are trying to use 'copy' command on sqlplus. Unfortunately, the=20 length of long raw is limit to 4000 bytes that is not long enough for the=20
data. I was wondering if any body knows a better way to do this. The=20 remote database is out of our control. So converting to blob is not an=20 option. Thanks in advance.

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 - 15:17:41 CDT