Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> copy long raw data from a remote database

copy long raw data from a remote database

From: David Boyd <davidb158_at_hotmail.com>
Date: Mon, 17 May 2004 11:52:38 -0400
Message-ID: <BAY2-F53ERErQ3X7rz60001b4b0@hotmail.com>


Hi List,

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

David



Watch LIVE baseball games on your computer with MLB.TV, included with MSN Premium! http://join.msn.click-url.com/go/onm00200439ave/direct/01/

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 - 10:53:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US