Re: How to rename a table ?

From: Roger Snowden <rsnowden_at_labinterlink.com>
Date: 1997/01/03
Message-ID: <01bbf98e$51fc92c0$096fc589@roger.labinterlink.com>#1/1

Tony DeFelice <tonyd_at_communique.net> wrote in article <32CC7AAD.4121_at_communique.net>...
> Atif Ahmad Khan wrote:
> >
> > Is this possible ? Also is this a good solution ? I looked up the
alter
> > table command in the SQL Reference manual and did not find a way to
rename
> > a table.
> > Atif Khan
> > aak2_at_ra.msstate.edu
>
> There is no way to rename a table in Oracle...

Simply incorrect.
The syntax is:

RENAME oldtable TO newtable;

Indexes will also be renamed. Received on Fri Jan 03 1997 - 00:00:00 CST