I have seen such tricks before.. And wonder how many brave DBAs really do
this (in Production and Mission Critical Databases).
I, for sure, will stay away from messing with SYS.anything if it is not
recommended by Oracle.
I am not Chuck Yeager !!
- Kirti
> -----Original Message-----
> From: Trassens, Christian [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 14, 2001 3:51 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Renaming a Column
>
> Well, it isn't recommend it but you can update the field name of sys.col$
> table.
>
> Regards.
>
> > -----Mensaje original-----
> > De: bipin sahani [SMTP:[EMAIL PROTECTED]]
> > Enviado el: miércoles 14 de febrero de 2001 7:05
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: Re: Renaming a Column
> >
> > In Oracle
> > It's not possible to rename a column.You can instead
> > use alias for that column name in your queries.
> > Or you have to create a new table from existing one
> > Drop existing table.And recreate a table by
> > selecting from new table.
> >
> > Regards
> > Bipin
> > --- Heikki Jantunen <[EMAIL PROTECTED]> wrote: >
> > Hi all,
> > >
> > > I need to rename some columns on my table. Any idea
> > > how to do that...
> > >
> > > Thanks in advance,
> > >
> > > Hessu
> > >
> >
> _________________________________________________________________________
> > > Get Your Private, Free E-mail from MSN Hotmail at
> > > http://www.hotmail.com.
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Heikki Jantunen
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX:
> > > (858) 538-5051
> > > San Diego, California -- Public Internet
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
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).
