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

"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
>
>

Version?

The LONG answer to this could also be long, I'm sad to say. But another answer might be to CLOB the thing.

And by the way, I do wish Oracle would practise as they preach, and remove longs from the data dictionary.

Regards,
Angry of Tunbridge Wells. Received on Thu Nov 21 2002 - 17:30:25 CST