Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Copying Long RAW
Jill wrote:
> I need to insert some rows into a table, selecting from another table
> through a dblink. I am unable to due to a long raw column. I cannot get
> the SQL*Plus copy command to work either. Is their a way, other than an
> export/import?
>
>
Yes there is, but you're not going to like this...
Since it is a raw column, I expect it to contain binary data. If you don't
want to use export/import, you'l have to write some program (C for
instance) to read the data and write it to a file, and than read that back
into the other database. This is like writing your own version of
export/import. Long columns always have been a pain in the backside. If it
is only charachter data, you can get away with it in plain SQL. But raw is
a bit more complex.
If there are other ways to do this, it is always some kind of export/import
construction.
--
Posted via CNET Help.com
http://www.help.com/
Received on Sat Oct 16 1999 - 04:00:36 CDT