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 -> copy data from one table to another

copy data from one table to another

From: Margaret Burwell <aj739_at_FreeNet.Carleton.CA>
Date: 12 Aug 1998 18:42:57 GMT
Message-ID: <6qsnnh$raf@freenet-news.carleton.ca>

I want to copy all the data in table1 to an identical table called table2.  One of the columns is datatype LONG. I have tried  

        create table table2 as select * from table1 ;  

and creating the table and then  

        insert into table2 (select * from table1);  

Both of these give me ORA-00997: illegal use of LONG datatype. Does anyone have any suggestions?  

Marg Received on Wed Aug 12 1998 - 13:42:57 CDT

Original text of this message

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