Re: Rename table

From: zifeng li <zifeng.li_at_compudigm.co.nz>
Date: Thu, 17 May 2001 18:19:38 +1200
Message-ID: <3B036D7A.D42E984B@compudigm.co.nz>

Thank you both Sybrand and Christopher,

Since there are always new comers in this community, your help would be much appreciated I am sure. Cheers, Zifeng

Sybrand Bakker wrote:

> "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 - 01:19:38 CDT