Re: copy data from one table to another

You must set the variable LONG properly before you can using Copy command in SQL*PLUS. If you do know the length of that column, you will get incorrect result.

So I suggest you use Export/Import and rename commands.

1. export table1
2. rename table1 to table3
3. import table1
4. rename table1 to table2
5. rename table3 to table2

Jin Lingang

> 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 Sun Aug 16 1998 - 22:06:46 CDT