Re: Rename table

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 17 May 2001 18:22:26 -0700
Message-ID: <3B047952.485A6EF2@exesolutions.com>

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

The following is quoted from 9i_new_features.pdf at technet.oracle.com:

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

So it is coming in just another month.

Daniel A. Morgan Received on Thu May 17 2001 - 20:22:26 CDT