Re: Can I rename Columns?
From: Joe Nardone <joe_at_access4.digex.net>
Date: 1995/09/24
Message-ID: <443tv0$r3r_at_news4.digex.net>#1/1
Date: 1995/09/24
Message-ID: <443tv0$r3r_at_news4.digex.net>#1/1
Noodles (noodles_at_aol.com) wrote:
: Continuing the thread...
:
: I understand the Insert statement in Oracle 7 does NOT support LONG data.
: Would I have to unload all of the data, drop the table, recreate a new
: table, and then reload ?
:
: Cliff
You could use the SqlPLUS COPY statement, which will copy longs. Make sure you SET LONG 5000 (or whatever the max length of the long is) or else it'll truncate them all to 80 chars.
Joe
--
=------------------------------------------------------------------------=
Joe Nardone |
joe_at_access.digex.net |
Received on Sun Sep 24 1995 - 00:00:00 CEST