Re: ORA-00997: How to copy the data from a table to another using long type

Hi Paolo,

check the copy Command of SQL-Plus.

you have to use something like

SQL> copy from user/pass_at_yourdatabasetns insert dest(column, ...)

     using select column,... from source;

check also set long etc. You have to set it to your longest long field.

hth.
s.kapitza

"Paolo Quaglia" <paoloquaglia_at_hotmail.com> wrote in message news:<arj0it$29rk$1_at_stargate1.inet.it>...
> Hi to all
> I have created this table with a long data type
>
> CREATE TABLE content (
> id_content number(16) NOT NULL,
> data_contenuto date NOT NULL,
> xml long
> );
>
> My intention is to add a column before the xml field
>
> I have created another table with the new field
>
> CREATE TABLE content2 (
> id_content number(16) NOT NULL,
> data_contenuto date NOT NULL,
> newfield varchar2(255),
> xml long
> );
>
> Now I HAVE TRIED TO COPY the vals from content to content2 using:
>
> INSERT INTO content2 SELECT * FROM content
>
> But Oracle says:
>
> ORA-00997: illegal use of LONG datatype
>
> How can I copy the data of a table with long to another diffirent
> table??????
>
> Thanks very much to all!!
> Paolo
Received on Fri Nov 22 2002 - 08:26:26 CST