Re: Copy a table with a long column

From: Rodney L. Barrett <rbarrett_at_solutionpt.com>
Date: 1998/01/20
Message-ID: <6a39ti$hdg@apple.telalink.net>#1/1

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