Re: Rename table

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 17 May 2001 07:06:36 +0200
Message-ID: <tg6musalailva0@beta-news.demon.nl>

"Christopher Latta" <nobody_at_nowhere.not> wrote in message

news:LkIM6.2851$mA4.83016_at_ozemail.com.au...

> Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
> news:tg6ik3dljvv98_at_beta-news.demon.nl...
> >
> > "zifeng li" <zifeng.li_at_compudigm.co.nz> wrote in message
> > news:3B033FB5.79BA9568_at_compudigm.co.nz...
> > > How to rename a table? Thanks. Zifeng
> > >
> >
> > Check out the rename command in the sql reference manual.
>
> Wow, I didn't know about that command. It wasn't in my DBA book.
>
> You still can't (as of 8.0.5 which I use) rename columns or drop them
> though, can you?
>
> Christopher Latta
>
>

Renaming a table has been possible since version 5. Apparently no one reads the Oracle docs, so that is why questions like this are appearing over and over again.
and BTW, no you can't rename a column, you can drop it or set it to unused in 8i. This is an architectural issue, so I don't think it will ever be possible to rename a column, nor should it be possible: You can always get a view on top of a table with an incorrectly named column.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu May 17 2001 - 00:06:36 CDT