Re: Rename table

Is the column rename feature a 9i only capability. I have an 8.0.5 and 8.1.5 DB in which I'd like to change a few column names. I haven't seen anything in the Oracle Docs concerning the column rename (found the table rename though).

If it isn't a 9i feature what's the syntax?

Thanks a bunch!
Earl

"Daniel A. Morgan" wrote:
>
> 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 Tue May 22 2001 - 11:31:44 CDT