Rachel, I agree with your statement but since you used the word "logically" , I questioned the workings of Oracle and why or how they do things. If I remember correctly you had to make a column "unusable" before you could drop it. It didn't make sense to me. Why not just drop the column and clean the data up at the next export/import/reorg or leave the data in the table and ignore the space used but not seen. There have been a few tips and hints listed on this list about making changes in the Oracle tables to accomplish desired tasks that were not supported by Oracle. Perhaps this is such an item that Oracle has decided to support after testing. I heard rumors of a future publication that is based on the "tips and hints" that accomplish what Oracle can not do with normal commands, but they work properly. Perhaps such a publication will help convince Oracle to test and incorporate them in release 10.x. Thanks, Ron ROR mô¿ôm
>>> [EMAIL PROTECTED] 05/22/02 02:25PM >>> 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). -- 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).
