Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: copy binary data to another database
you can't use "insert into ... select ... from ..." on binary datatype. use
exp/imp instead.
"David Nguyen" <nguyend4_at_hotmail.com> wrote in message
news:9a0092d.0302261046.46223a5_at_posting.google.com...
> Hi all,
>
> I'm trying to copy 1 row of binary data from 1 table of 1 database
> to another table (same structure) of different database. It's long
> raw datatype in Oracle 9i and I use insert SQL
>
> Howver I get the following error:
>
> illegal long datatype
>
> Can someone help me
>
> Thanks
>
> David
Received on Wed Feb 26 2003 - 13:35:52 CST
![]() |
![]() |