Re: rename a column

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Wed, 22 May 2002 03:09:07 GMT
Message-ID: <B91059DF.23FB6%markbtownsend@attbi.com>

in article f369a0eb.0205211821.27e11026_at_posting.google.com, D.Y. at dyou98_at_aol.com wrote on 5/21/02 7:21 PM:

> Mark Townsend <markbtownsend_at_attbi.com> wrote in message
> news:<B90D37F9.23A86%markbtownsend_at_attbi.com>...

>> in article ac78pm$jfs$1_at_lust.ihug.co.nz, Howard J. Rogers at dba_at_hjrdba.com
>> wrote on 5/18/02 9:12 PM:
>> 
>>> Actually perfectly possible in 9i release 1.
>> 
>> Release 1 - Online redefinition - requires CTAS
>> Release 2 - Rename in place

>
> What I don't understand is why Oracle wanted to go through the
> trouble of creating a dbms_redefinitions package if they planned
> to implement "rename in place", which seems much easier.

Because you can use redefinition to do a lot more than just rename a column. Basically you can perform any DML change via re-definition. Also, redefinition is an online operation (the table is not locked during the operation). Received on Tue May 21 2002 - 22:09:07 CDT