Re: changing long col to varchar and vice versa

From: <DBarbour_at_austin.isd.tenet.edu>
Date: Thu, 16 Aug 2001 12:54:18 -0700
Message-ID: <F001.0036DECE.20010816130817@fatcity.com>

Export and Import

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

                                                                                       
                       
                    Schoen Volker                                                      
                       
                    <v.schoen_at_inpl       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>  
                    an.de>               cc:                                           
                       
                    Sent by:             Subject:     changing long col to varchar and 
vice versa             
                    root_at_fatcity.c                                                     
                       
                    om                                                                 
                       
                                                                                       
                       
                                                                                       
                       
                    08/16/2001                                                         
                       
                    10:31 AM                                                           
                       
                    Please respond                                                     
                       
                    to ORACLE-L

Hi list,

I want to change col-types in one table. I have table T1 with two columns COL1 LONG and COL2 VARCHAR2(2000). Now I want to change the col-types vice versa, that means COL1 should be VARCHAR2(2000) and COL2 should be LONG. I have a lot of data in that cols, but all data is smaller than 2000 characters.

Could someone tell how to convert these columns?

TIA Volker Schön
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Schoen Volker
INET: v.schoen_at_inplan.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: DBarbour_at_austin.isd.tenet.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message