Re: copying large LONG RAW value between databases
From: Karth Panchan <keyantech_at_gmail.com>
Date: Tue, 28 Apr 2015 00:25:22 -0400
Message-Id: <ECD6326D-E73E-40A0-9AC2-4627E48FA27E_at_gmail.com>
Adric
>
> 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.
>
> Other option check asktom.oracle.com for "copy long column". That has best solution.
>
> I'll check again, but everything I've found there so far was only applicable to LONG rather than LONG RAW.
>
> Thanx for the suggestions.
>
> --
> "In the beginning the Universe was created. This has made a lot of people very angry and been widely regarded as a bad move." -Douglas Adams
>
>
>
> --
> "In the beginning the Universe was created. This has made a lot of people very angry and been widely regarded as a bad move." -Douglas Adams
Date: Tue, 28 Apr 2015 00:25:22 -0400
Message-Id: <ECD6326D-E73E-40A0-9AC2-4627E48FA27E_at_gmail.com>
Adric
You can try "Long Raw to BLOB" on asktom.oracle.com
Using TO_LOB may be helpful to you.
I implemented only for LONG data type.
HTH
Karth
Sent from my IPhone
> On Apr 27, 2015, at 7: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.
>
> Other option check asktom.oracle.com for "copy long column". That has best solution.
>
> I'll check again, but everything I've found there so far was only applicable to LONG rather than LONG RAW.
>
> Thanx for the suggestions.
>
> --
> "In the beginning the Universe was created. This has made a lot of people very angry and been widely regarded as a bad move." -Douglas Adams
>
>
>
> --
> "In the beginning the Universe was created. This has made a lot of people very angry and been widely regarded as a bad move." -Douglas Adams
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 28 2015 - 06:25:22 CEST