Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Copy rows with LONG RAW
Hi,
I know only one way using Oracle Call Interface. You can use exp/imp approach or my Table Copy freeware utility:
Andrew Protasov
> I try to copy rows with LONG RAW column.
>
> Of course, INSERT...SELECT... won't work, i tried.
>
> Then I do is :
> FOR C1 IN (SELECT LONG_RAW_COL FROM TABLE_A) LOOP
> INSERT INTO TABLE_B VALUES(C1.LONG_RAW_COL);
> END LOOP;
>
> It works, but only for < 64K, not max. 2G of LONG RAW column.
>
> I also try to declare a long raw PL/SQL variable and do simple
> manupulations, same case also happen.
>
> Anybody know why and have a solution ?
>
> Thx.
Received on Mon Nov 23 1998 - 00:13:57 CST