Re: copy data from one table to another

Did you try using copy command in sql*plus:

copy from username/password
create table_to
using
select * from table_from;

raghuvir

Margaret Burwell <aj739_at_FreeNet.Carleton.CA> wrote in article <6qsnnh$raf_at_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 Fri Aug 14 1998 - 22:56:58 CDT