RE: Column Rename

From: <Jared.Still_at_radisys.com>
Date: Wed, 23 Jan 2002 12:07:25 -0800
Message-ID: <F001.003F917F.20020123115756@fatcity.com>

Both an Oracle DBA instructor and myself have encountered some rather nasty results from changing column names in the data dictionary.

I was able to recover from my predicament. :)

He wasn't. :(

Jared

"Deshpande, Kirti" <kirti.deshpande_at_verizon.com> Sent by: root_at_fatcity.com
01/23/02 07:55 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: Column Rename

Simple answer is no.
There is no single command to do it, officially.

However, there other tricks to achieve the goal. One involves messing with data dictionary objects. Search Steve Adam's site http://www.ixora.com.au/. I believe he had a script to demo how it can be done. But with a WARNING that this operation is not supported by Oracle.

Other suppored solutions involve re-creating the table, one way or the other. One way is to exchange the table with a partition and back to table.
The note detailing this with an example is on Metalink.

Or you can build a view for this table with correct column name.

Even Oracle 9.0.1 does not have an easy way to it. One has to use the new procedure of 'table redefinition' to achieve this.

HTH,

Kirti

-----Original Message-----
[mailto:systems_ho/VGIL_at_vguard.satyam.net.in] Sent: Wednesday, January 23, 2002 5:25 AM To: Multiple recipients of list ORACLE-L

Hello

Is it possible to rename a column in Oracle 8 ( Release 8.0.3.0.0 )?

Regards
Systems

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- n

Author:
INET: systems_ho/VGIL_at_vguard.satyam.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: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------