Rename table

From: Kees Avontuur <c.p.a.avontuur_at_kub.nl>
Date: 14 Dec 2001 08:29:28 GMT
Message-ID: <9vcd98$e0q$1@mailnews.kub.nl>

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 - 02:29:28 CST