Re: copy data from one table to another

From: Marcus Reichardt <mr_at_diamanda.hh.eunet.de>
Date: Thu, 13 Aug 1998 12:54:52 +0200
Message-ID: <35D2C5FC.3D27@diamanda.hh.eunet.de>

Margaret Burwell wrote:
>
> 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

Oracle doesn't allow LONG datatypes in these kind of operations. You could use the COPY command of SQL*Plus instead.

Marcus Reichardt
Consultant Received on Thu Aug 13 1998 - 05:54:52 CDT