Re: Rename a Oracle table

From: Yong Huang <yong321_at_yahoo.com>
Date: 29 Oct 2002 11:15:28 -0800
Message-ID: <b3cb12d6.0210291115.3de4f348@posting.google.com>

"gamaz" <gamaz_at_earthlink.net> wrote in message news:<mWTu9.8834$6F4.759228_at_newsread2.prod.itd.earthlink.net>...
> Hi, is there any way to rename a Oracle table? Is it at all possible to do
> so? Thanks in advance.

Both ALTER TABLE RENAME TO and RENAME TO can do it. In case you wonder what the difference is between them, there's none when you rename a table. But RENAME can also be used against "view, sequence, or private synonym for a table, view, or sequence".

Yong Huang Received on Tue Oct 29 2002 - 13:15:28 CST