Re: copying large LONG RAW value between databases

From: Adric Norris <landstander668_at_gmail.com>
Date: Tue, 28 Apr 2015 09:23:49 -0500
Message-ID: <CAJueESpG-xrzmJpoDUBdWRbCFHnDnuhzdGS9ngG4nVfSG5ZTTA_at_mail.gmail.com>

I just doublechecked the SQL Plus COPY command, using the 12.1.0.2.0 full client for Windows. It yields a "CPY-0012: Datatype cannot be copied" error when trying to process a LONG RAW column.

That one's definitely off the table, unfortunately.

On Mon, Apr 27, 2015 at 6:50 PM, Adric Norris <landstander668_at_gmail.com> wrote:

> Sorry... forgot to CC the list.
>
> ---------- Forwarded message ----------
> From: Adric Norris <landstander668_at_gmail.com>
> Date: Mon, Apr 27, 2015 at 6:49 PM
> Subject: Re: copying large LONG RAW value between databases
> To: Karth Panchan <keyantech_at_gmail.com>
>
>
> On Mon, Apr 27, 2015 at 3:23 PM, Karth Panchan <keyantech_at_gmail.com>
> wrote:
>
>> Adric
>>
>> You can use SQL Plus COPY command to manually copy across DB's.
>>
>
> That doesn't work for LONG RAW, unfortunately. Or at least it didn't last
> time I checked, back in the 10gR2 / 11gR1 timeframe... pretty sure that's
> till the case, since the datatype has been deprecated for so long.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 28 2015 - 16:23:49 CEST