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@xxxxxxxxx>
wrote:
Sorry... forgot to CC the list.
---------- Forwarded message ----------
From: Adric Norris <landstander668@xxxxxxxxx>
Date: Mon, Apr 27, 2015 at 6:49 PM
Subject: Re: copying large LONG RAW value between databases
To: Karth Panchan <keyantech@xxxxxxxxx>
On Mon, Apr 27, 2015 at 3:23 PM, Karth Panchan <keyantech@xxxxxxxxx>
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.