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 <[EMAIL PROTECTED]> 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 > > >>> [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] > ---------------------------------------------------------------------------- > ---------------------------------------------------------------------------- > ------------------------ > 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: [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: Ron Rogers > 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). __________________________________________________ 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: [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).
