Re: Rename Column in 9iR2

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 <ORACLE-L_at_fatcity.com> 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"
> <ORACLE-L_at_fatcity.com>
> Reply-to: ORACLE-L_at_fatcity.com
> 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
>
> >>> ktoepke_at_trilegiant.com 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
>
> >>> ktoepke_at_trilegiant.com 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
> ktoepke_at_trilegiant.com
>
>
>
> __________________________________________________
> 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: keithpson_at_yahoo.com
>
> 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: Yechiel Adar
  INET: adar76_at_inter.net.il

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