Re: Rename table

From: Glebsky <glebsky_at_gmx.net>
Date: Fri, 14 Dec 2001 16:30:59 +0600
Message-ID: <3C19D4E3.5F0B36F3@gmx.net>

Hi Kees,
  Oracle will replace values of all TABLE_NAME columns in all dictionary tables in one
  transaction, i.e. all or nothing.
  During last three years I didnt see when failed to RENAME something at all.

  RENAME will save all data, all grants, all indexes (but not index names), all constraints
  (but not their names) ... -- everything.   Thus, if you rename table TAB1 with primary key PK_TAB1 to TAB2, than
  you will get TAB2 but with primary key still called PK_TAB1.

Regards

Kees Avontuur wrote:

> Hello all,
>
> What exactly happens when a table is renamed.
> Is this just a one row update in an Oracle system table?
> And what happens if the rename has failed? Is the
> original table still available? The problem is that
> it is difficult to test this. The only thing that can be done
> is to test the rename when the new table name already exists.
> But what happens when the new table new does not exist, and
> the rename fails?
>
> Kees Avontuur
> K.U.B. Tilburg
>
> Mailto: c.p.a.avontuur_at_kub.nl
Received on Fri Dec 14 2001 - 04:30:59 CST