Copy long raw data from a remote database

From: David Boyd <davidb158_at_hotmail.com>
Date: Mon, 17 May 2004 13:54:44 -0400
Message-ID: <BAY2-F28bC8wSA1XvpF0001ba1a@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

FREE pop-up blocking with the new MSN Toolbar – get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/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 - 12:51:41 CDT