Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: rename a column
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. Received on Tue May 21 2002 - 21:21:09 CDT
![]() |
![]() |