Copy I don't believe will work with a long raw column.
The easiest way I have done it is to export the table using exp. rename the
orig table, then import the old back into the system.
--
Robert Fazio
Senior Technical Analyst
dbabob_at_yahoo.com
"Mathew Smith" <mat_at_dcs.bbk.ac.uk> wrote in message
news:3B4D9F6F.81BE6B73_at_dcs.bbk.ac.uk...
> Hi,
>
> I wonder if you can help? I have a table containing two columns, one of
> type 'varchar 'the other of type 'long raw' (see SQL data definition
> code below) and I wish to copy the data contained within this table into
>
> another table that contains the same columns, with the same names and
> corresponding types. I have gathered that Oracle (I am using version
> 8.1.7.0.0) has a command 'copy' that may be used for this purpose;
> however I am not familiar enough with the command to use it for this
> purpose. If you could mail me the SQL*Plus code required to complete
> this task it would be much appreciated.
>
> Thank you for your time
>
> Mat
>
> create table Pictures
> (
> pictureId varchar(70),
> picture long raw
> );
>
>
>
Received on Thu Jul 12 2001 - 16:53:37 CDT
