Re: Problem with LONG column

Look into the SQL*Plus COPY command.

> BanarasiBabu Tippa wrote:
>
> Hi everyone
>
> One of my development team is working on ORACLE 8 on NT (Because of
> client requirement they are working on that version). One Table was
> created with wrong column name. Now they wanted me to correct the
> column name. But real problem is one column of that table is LONG data
> type. So I was unable to use
> Insert into ... Select .... statement. Any suggestions in this
> regard highly appreciated.
>
> thanks
> Banarasi Babu T
> OCP, DBA
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Suzy Vordos
  INET: lvordos_at_qwest.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).