Upgrade to 9iR2 today. Rename column does not work in 9.0.1. Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 22, 2002 9:30 PM
> If those times are right... its a functionality you > should not live without, its a direct money saver. > Upgrade to 9i today! > > hats off to Oracle marketing... "if and when the > database sales lose traction... we will release RENAME > COLUMN"... and 20 years later... here it is. > > Keith > > Date: Wed, 22 May 2002 10:41:32 -0800 > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Reply-to: [EMAIL PROTECTED] > Organization: Fat City Network Services, San Diego, > California > > > Kevin, > I appreciate your testing efforts. Now to convince > the bean-counters > to upgrate to 9i. > Ron > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 05/22/02 02:08PM >>> > I reran my test. with 250,000 rows in the table. It > took a whopping > 0.25 > seconds to complete. > > -----Original Message----- > Sent: Wednesday, May 22, 2002 12:59 PM > To: Multiple recipients of list ORACLE-L > > > Kevin, > Yes but does it work with data in the column?, I do > not have 9i set > up > yet. If it works as you describe with data in the > column it will > really > help with the multi million row tables that "they" > want to rename a > column after a release of a new lotto game. > thanks, > for the test and update. > Ron > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 05/22/02 10:38AM >>> > Summary: it works! > > SQL> SELECT * FROM v$version; > > BANNER > ---------------------------------------------------------------- > Oracle9i Enterprise Edition Release 9.2.0.1.0 - > Production > PL/SQL Release 9.2.0.1.0 - Production > CORE 9.2.0.1.0 Production > TNS for Solaris: Version 9.2.0.1.0 - Production > NLSRTL Version 9.2.0.1.0 - Production > > SQL> create table test_table (wrong_name > VARCHAR2(40)); > > Table created. > > SQL> alter table test_table rename column wrong_name > to right_name; > > Table altered. > > SQL> desc test_table; > Name Null? > Type > ----------------------------------------- -------- > ---------------------------- > RIGHT_NAME > VARCHAR2(40) > > SQL> > > Kevin Toepke > [EMAIL PROTECTED] > > > > __________________________________________________ > Do You Yahoo!? > LAUNCH - Your Yahoo! Music Experience > http://launch.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Keith Peterson > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Yechiel Adar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).