Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.
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