Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-00997: How to copy the data from a table to another using long type

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

From: Paolo Quaglia <paoloquaglia_at_hotmail.com>
Date: Thu, 21 Nov 2002 17:11:08 +0100
Message-ID: <arj0it$29rk$1@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 Thu Nov 21 2002 - 10:11:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US