Re: Copying an entire table that has a LONG field.
Date: 29 Jun 2001 22:40:55 -0700
Message-ID: <2cf4efe2.0106292140.63fc7666_at_posting.google.com>
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
Hello,
If you intend to do the above from SQL*Plus, you can use the copy command as follows..
copy from uid/pwd_at_TNSServiceName to uid/pwd_at_TNSServiceName -
append DestinationTable -
using select * from SourceTable;
Regards
Bhooshan
Received on Sat Jun 30 2001 - 07:40:55 CEST