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
>>> wisernet100_at_yahoo.com 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 <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).
--
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).
Received on Wed May 22 2002 - 14:00:50 CDT
