RE: Renaming columns ...

Oops! My apology. It was for datatype changed. Erased what I said.

-----Original Message-----
Sent: Monday, June 04, 2001 1:59 PM
To: Multiple recipients of list ORACLE-L

How does it know which column to rename?

At 11:21 AM 6/4/01 -0800, you wrote:
>ALTER TABLE table_name MODIFY ( new_col_name DATATYPE);
>
>It works for me in 8i.
>
>
>
>
>
>
>-----Original Message-----
>Sent: Monday, June 04, 2001 11:27 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Chris:
>
>I've been browzing the on-line docs for 9i and the release notes and have
>seen nothing about renaming a column...can you point me to the location in
>the docs that give the syntax?
>
>Thanks
>Kevin
>
>-----Original Message-----
>Sent: Monday, June 04, 2001 1:17 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Yes renaming a column is supported, in fact you can change almost every
>aspect of a table online.
>it works parallel to existing table, right before switching them over, it
>gets the latest DML applied, then switches over.
>
>
>"Walking on water and developing software from a specification are easy if
>both are frozen."
>
>Christopher R. Spence
>Oracle DBA
>Fuelspot
>
>
>
>-----Original Message-----
>Sent: Monday, June 04, 2001 11:27 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi Raj,
> 1. There is a way to do it. And Mr. Steve A. has some good info about it
(&
>its implications) on his web site. (Sorry I do not have a direct URL link
to
>it). I believe this works for all versions.
> 2. Yes, it does. I have played with it on my test database.
>
> However, I will not do this on a Production database as it involves a
>direct DML to modify sys.COL$. And Oracle does not recommend doing such
>things to your databases.
>
>I am not sure if renaming column is supported in 9i. Anyone else know for
>sure?
>
>If you are using 8i, the safe way to address this is to add a new column to
>the table, populate it with the contents from the old, and drop the old
>column. If the column is not nullable, and if there are plenty of nullable
>columns towards the end of the table, I suggest considering reorganization
>of the table. I just did that (reorg) in the last couple of weeks with a
>60Mil row table to get the new & not nullable columns towards the 'head' of
>the table.
>
>HTH,
>
>Regards,
>
>- Kirti Deshpande
> Verizon Information Services
> http://www.superpages.com
>
> > -----Original Message-----
> > From: Jamadagni, Rajendra [SMTP:Rajendra.Jamadagni_at_espn.com]
> > Sent: Monday, June 04, 2001 8:51 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Renaming columns ...
> >
> > 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 !
> >
>--
>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: Christopher Spence
> INET: cspence_at_FuelSpot.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: Toepke, Kevin M
> INET: ktoepke_at_cms.cendant.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: PHU,JULIA (HP-Sunnyvale,ex2)
> INET: julia_phu_at_hp.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: Regina Harter
  INET: rharter_at_emc-inc.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: PHU,JULIA (HP-Sunnyvale,ex2)
  INET: julia_phu_at_hp.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).