Re: copy data to a new table

aj739_at_FreeNet.Carleton.CA (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

You can't CREATE as SELECT from a table that contains a long. You can use the SQL*Plus COPY command.

David
x53447

David Greensmith :-)
(david_at_green1.demon.co.uk) Received on Thu Aug 13 1998 - 10:57:41 CDT