RE: Renaming columns ...

There is an oracle-supplied *.sql file to do this ...in the rdbms/admin directory as i recall. You will, of course, have to RTFM online and do some tinkering.

I am so old that I can't remember much more about this, but anything to do with "Diana" sure perks me up.

ahem.

|| -----Original Message-----
|| From: Joseph Raj [mailto:rkjoseph_at_now-india.net.in]
|| Sent: Monday, June 04, 2001 12:46 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: Renaming columns ...
||
||
|| This is right from Guru Steeve Adam's site
||
|| "No, if the table is referred to in any stored PL/SQL
|| program units, you
|| must first drop those program units and then manually delete
|| the rows for
|| that table (based on its OBJ# from OBJ$) from the 4 data
|| dictionary tables
|| beginning with IDL. The IDL tables contain the DIANA for the
|| table, which
|| includes a knowledge of the old column name. That is why you
|| need to get rid
|| of it. If you do this, it is perfectly safe to change column
|| names directly,
|| even with stored PL/SQL.
|| Please note, however, that it is also perfectly unsupported.
|| So think twice
|| before doing this on a production system. The supported way
|| to solve this
|| problem is to rename the table, and interpose a view to
|| translate the column
|| name. "
||
|| ps check up http://www.ixora.com.au
|| and do a search. this was from one of the q&a of 99.
||
|| regards & hth,
|| Joseph Raj Kumar
|| ----- Original Message -----
|| To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
|| Sent: Monday, June 04, 2001 7:20 PM
||
||
|| > Hi all,
|| >
|| > although I am searching information on Metalink and OTN, I
|| just want to
|| ask
|| > this question to the list ...
|| >
|| > 1. Is it possible to rename a column? (we have lots of
|| columns that need
|| to
|| > be renamed). Which version supports it?
|| > 2. Does renaming automatically takes care of indexes?
|| >
|| > Coding will be a lot of manual labor, but that's okay we
|| can handle it.
|| >
|| > Thanks in advance
|| > Raj
|| > ______________________________________________________
|| > Rajendra Jamadagni MIS, ESPN Inc.
|| > Rajendra dot Jamadagni at ESPN dot com
|| > Any opinion expressed here is personal and doesn't reflect
|| that of ESPN
|| Inc.
|| >
|| > QOTD: Any clod can have facts, but having an opinion is an art !
|| >
|| >
|| >
|| >
|| *************************************************************
|| ********1
|| >
|| > This e-mail message is confidential, intended only for the named
|| recipient(s) above and may contain information that is
|| privileged, attorney
|| work product or exempt from disclosure under applicable law.
|| If you have
|| received this message in error, or are not the named
|| recipient(s), please
|| immediately notify corporate MIS at (860) 766-2000 and
|| delete this e-mail
|| message from your computer, Thank you.
|| >
|| >
|| *************************************************************
|| ********1
|| >
|| > --
|| > Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| > --
|| > Author: Jamadagni, Rajendra
|| > INET: Rajendra.Jamadagni_at_espn.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: Joseph Raj
|| INET: rkjoseph_at_now-india.net.in
||
|| 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: Mohan, Ross
  INET: MohanR_at_STARS-SMI.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).