Re: Copying an entire table that has a LONG field.

andresp_at_usa.net (Andres Portillo) wrote in message news:<fa121199.0106291330.515a1850_at_posting.google.com>...
> Hi,
>
> I'm trying to copy all the information from one table to another,
> using
> the next command:
>
> insert into table_cp select * from table;
>
> then I get this error msg: ORA-00997: illegal use of LONG datatype, it
> seems
> that this operation does not work b/c the table have one column of
> type LONG.
> Does somebody know if there's a workaround for this problem, I haven't
> been able to found any relevant in the documentation. (I can always
> write
> an small program but I want to avoid doing it if possible).
>
> Thanks in advance.
>
> andres

Hi,
Try to use sqlplus COPY command it allows to copy data between tables which consist long data types. Remember to set long to apt value (set long 1000000).
HTH,
Andrey Goryunov Received on Sat Jun 30 2001 - 09:10:34 CEST