Re: renaming a cloumn

watchdog wrote:
>
> Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:<9v694g02bd6_at_drn.newsguy.com>...
> > In article <3C169496.CD6C5F63_at_web.de>, Holger says...
> > >
> > >Hi,
> > >
> > >this is not correct. I think since 8.1.7 it is possible to rename columns.
> > >I have done it a few weeks ago, but can't remember the syntax.
> > >If you have installed the help you should a have a look at the parameters for
> > >"alter table modify column". I think it was "move" but I'm not sure.
> > >
> >
> > nope, you cannot rename a column. you did something else.
> >
> > you can 'move' a table, you cannot rename a column.
> >
> >
> >
> > >Hope this helps,
> > > Holger
> > >
> > >Sue Wi-Afedzi schrieb:
> > >
> > >> You can't rename a column, but you can add a new column with the new name,
> > >> (alter table add ...), populate it with the values of the first column, then
> > >> drop the first column (alter table drop column <column name>). The
> > >> database must be 8i or higher and the owner of the table cannot be SYS.
> > >>
> > >> Hope that helps.
> > >>
> > >> Sue
> > >> "Najm Hashmi" <najmh_at_videotron.ca> wrote in message
> > >> news:wtjR7.18657$2F2.1189458_at_weber.videotron.net...
> > >> > Hi All,
> > >> > What is the correct syntax to rename a column in a table using alter table
> > >> > command.
> > >> > Thanks in advance.
> > >> > Regards, Najm
> > >> >
> > >> >
> > >
> Try this if u want.
>
> sqlplus>connect sys/*******
> sqlplus>update col$ set name='NEW_COLUMN_NAME' where obj#=(select obj#
> from obj$ where name='UR_TABLE_NAME' and owner#=(select user# from
> user$ where name='UR_ACCOUNT') ) and name='OLD_COLUMN_NAME';
> sqlplus>commit;
> sqlplus>alter system flush shared_pool;
> sqlplus>desc ur_account.ur_table_name

He may as well 'vi' the datafile for the system tablespace and have a hack around in that as well...

9i supports redefintion of all sorts of dictionary data.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."