RE: Renaming a Column

>From the 9i New Features Doc -

Online Data Evolution

In this new architecture the contents of the table are copied into a new table.
While the contents are copied, the updates to the original table are tracked by the
database. After the copy completes, the updates are applied to the new table.
Once the updates are applied, indexes can be created on the new table. After the
indexes are created, any additional updates are applied and the result table replaces the original table. The table is only locked in exclusive mode at the
beginning and end of the operation, when the dictionary data is updated.

Using this new architecture, any physical attribute of the table can be changed
online. The table can be moved to a new location. The table can be partitioned.
The table can be converted from one organization (e.g. heap) to another (e.g.
index organized).

Additionally, many logical attributes can be changed. Column names, types, and
sizes can be changed. Columns can be added, deleted, or merged. The primary restriction is that the primary key of the table cannot be modified.

-----Original Message-----
Kirti
Sent: Wednesday, February 14, 2001 01:27 To: Multiple recipients of list ORACLE-L

I didn't find it any of my docs for 8.1.7 either. Is renaming a column getting confused with dropping a column?

For renaming columns, one has to wait till 9i is a reality, I was told....

• Kirti

> -----Original Message-----
> From: Joseph S. Testa [SMTP:teci_at_oracle-dba.com]
> Sent: Wednesday, February 14, 2001 6:10 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Renaming a Column
>
> Ok i'll bite, i try to keep up with the new features and i'm looking at
> 8i(8.1.7) docs right now and i dont see it, would you like to elaborate?
>
> you can rename a table, rename a partition but NOT rename a column, this
> has been on the wish-list for many years just like drop column was.
>
> Feel free to flame me if i'm wrong(it does happen but rarely) :)
>
>
> joe
>
> "Johan Locke_at_i-Commerce Services" wrote:
> >
> > Wait wait wait...
> >
> > Yes you can rename a column in 8i, it just depends to what value your
> > compatibility parameter is set
> >
> > Regards
> > JL
> >
> > -----Original Message-----
> > Sent: Wednesday, February 14, 2001 8:05 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > 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 <hjantunen_at_hotmail.com> 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: hjantunen_at_hotmail.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).
> >
> > ____________________________________________________________
> > Do You Yahoo!?
> > Get your free @yahoo.co.in address at http://mail.yahoo.co.in
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: =?iso-8859-1?q?bipin=20sahani?=
> > INET: bipinsahani_at_yahoo.co.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: Johan Locke_at_i-Commerce Services
> > INET: Johan.Locke_at_za.didata.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).
>
> --
> Joe Testa http://www.oracle-dba.com
> Performing Remote DBA Services, need some backup DBA support?
> For Sale: Oracle-dba.com domain, its not going cheap but feel free to
> ask :)
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joseph S. Testa
> INET: teci_at_oracle-dba.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: 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
--------------------------------------------------------------------
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: Mark Leith
  INET: mark_at_cool-tools.co.uk

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).