Ron,
I can't test it here, but logically it seems it shouldn't matter if
there is data in the column or not as column_name is NOT stored within
the table itself but within the data dictionary.
Rachel
- Ron Rogers <RROGERS_at_galottery.org> wrote:
> 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
>
>
> ------------------------
> The information in this electronic mail message is Trilegiant
> Confidential
> and may be legally privileged. It is intended solely for the
> addressee(s).
> Access to this Internet electronic mail message by anyone else is
> unauthorized. If you are not the intended recipient, any disclosure,
> copying, distribution or action taken or omitted to be taken in
> reliance on
> it is prohibited and may be unlawful.
>
>
> ------------------------
> The sender believes that this E-mail and any attachments were free of
> any
> virus, worm, Trojan horse, and/or malicious code when sent. This
> message and
> its attachments could have been infected during transmission. By
> reading the
> message and opening any attachments, the recipient accepts full
> responsibility for taking protective and remedial action about
> viruses
> and
> other defects. Trilegiant Corporation is not liable for any loss or
> damage
> arising in any way from this message or its attachments.
>
>
> ------------------------
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Toepke, Kevin M
> INET: ktoepke_at_trilegiant.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: Ron Rogers
> INET: RROGERS_at_galottery.org
>
> 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).
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_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).
Received on Wed May 22 2002 - 13:25:36 CDT