Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Copy a table with a long column

Copy a table with a long column

From: Don Brown <don_brown_at_rl.gov>
Date: 1998/01/19
Message-ID: <34C3EE08.2A4B@rl.gov>#1/1

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 Mon Jan 19 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US