Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: copy binary data to another database

Re: copy binary data to another database

From: Life Learner <PowerE2E_at_yahoo.com>
Date: Wed, 26 Feb 2003 19:35:52 GMT
Message-ID: <sG87a.341956$sV3.10435162@news3.calgary.shaw.ca>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US