Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: rename a column

Re: rename a column

From: D.Y. <dyou98_at_aol.com>
Date: 21 May 2002 19:21:09 -0700
Message-ID: <f369a0eb.0205211821.27e11026@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US