Re: ORA-00997: illegal use of LONG datatype

Oracle does not permit you to use a long field in that way. Then again, there isn't much you can do with a long!

You may have to use some tool to extract the data you want inti a temp table and load them later.

M

Dimitri R. de Souza wrote in message
<7jiune$67a$1_at_srv4-poa.nutecnet.com.br>...
>Hi!
>
>I'm trying to copy some rows of one table to other with exactly the same
>strutcture with the command "INSERT INTO <table1> SELECT * FROM <table2>",
>but I'm having some troubles: if the table has any field of type "LONG
RAW",
>when the command is executed, the Oracle returns the error "ORA-00997:
>illegal use of LONG datatype".
>
>Any help or ideia? I'm using Oracle 8.0.4....
>
>Thanks,
>
>Dimitri
>
>
Received on Tue Jun 08 1999 - 07:06:39 CDT