Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Copy a table with a long column
Use the copy command in SQLPLUS. you can copy within the same instance.
Don Brown wrote in message <34C3EE08.2A4B_at_rl.gov>...
>I need to copy a table to another, but the tables have one long
>column. I tried:
>
> insert into rm_last select * from rm;
>
>but got the following error:
>
> ORA-00997: illegal use of LONG datatype
>
>Can someone tell me the easiest way to do this?
>
>thanks,
>Don
>Lockheed Martin Services, Inc.
>(509) 376-6990
>don_brown_at_rl.gov
Received on Tue Jan 20 1998 - 00:00:00 CST