Re: Rename table

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

A rename is simply that - an update to the data dictionary. The table is not moved/rebuilt/altered etc.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."