Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-00997: How to copy the data from a table to another using long type
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