RE: Copy long raw data from a remote database

From: Hand, Michael T <HANDM_at_polaroid.com>
Date: Mon, 17 May 2004 15:02:23 -0400
Message-ID: <1357B9FD14F9D41187800008C7A47B350336A57F@corpa1.polaroid.com>

David,
I hope I'm not missing something obvious in your question, but what's wrong with
exp/imp in this case?

Mike

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

From: David Boyd [mailto:davidb158_at_hotmail.com] Sent: Monday, May 17, 2004 1:55 PM
To: oracle-l_at_freelists.org
Subject: Copy long raw data from a remote database

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

--

This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Mon May 17 2004 - 13:59:57 CDT