Re: trying to copy a long raw column

OK - so I guess there's no way then. Thanks for the info anyways. JR

"hy" <hueyyann_at_singa.pore.net> wrote:

>here's something from the Oracle manual
>
>LONG columns cannot be used in the SELECT list of a subquery or queries
>combined by set operators (UNION, UNION ALL, INTERSECT, or MINUS).
>LONG columns cannot be referenced when creating a table with a query (CREATE
>TABLE . . . AS SELECT . . .) or when inserting into a table (or view) with a
>query (INSERT INTO . . . SELECT . . .).
>
>I think u may have to insert the row without the LONG value and then update
>the row.
>
>~hy
>
>Jeremy Russell wrote in message <3617b23f.19501426_at_news.dircon.co.uk>...
>>I have a table set up with a 'Long Raw' column, that contains picture
>>information. The pictures display just fine in D/2000 - however, I
>>would like to copy selected rows from the table. Using the SQL
>>statement
>>
>>create table copy as select * from original
>>
>>only produces the error "ORA-00997: illegal use of LONG datatype" - if
>>I create with "where 1=0" - I get the same - if I create a fresh and
>>empty table and "insert into copy select * from original" - I get just
>>the same again.
>>
>>How am I using the LONG datatype illegally?
>>
>
>
>
>
>
>
Received on Sun Oct 11 1998 - 00:00:00 CEST