Re: Rename table

From: Kees Avontuur <c.p.a.avontuur_at_kub.nl>
Date: 18 Dec 2001 07:24:20 GMT
Message-ID: <9vmqv4$30s$1@mailnews.kub.nl>

In article <3C19D4E3.5F0B36F3_at_gmx.net>, Glebsky <glebsky_at_gmx.net> wrote:
>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
>

Thanks four your information Glebsky, also to Connor McDonald.

Kees Avontuur
K.U.B. Tilburg

Mailto: c.p.a.avontuur_at_kub.nl Received on Tue Dec 18 2001 - 01:24:20 CST