Re: Rename a Oracle table

From: Peter van Rijn <p.vanrijnREMOVE_at_THISzhew.nl>
Date: Wed, 30 Oct 2002 10:40:40 +0100
Message-ID: <urvadtjtu6r311@corp.supernews.com>

You're not spoiling this beautiful political discussion by getting to the point are you ;-))

Peter

"Yong Huang" <yong321_at_yahoo.com> schreef in bericht news:b3cb12d6.0210291115.3de4f348_at_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 Wed Oct 30 2002 - 03:40:40 CST