Re: rename a column

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Mon, 20 May 2002 05:23:48 +1000
Message-ID: <ac8u6e$1oq$1@lust.ihug.co.nz>

"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

Depends how you define CTAS, doesn't it? The table remains online throughout with dbms_redefinition, and the interim table is refreshable... a key feature that 'traditional' CTAS lacks. But yes, you have to re-grant permissions and so on. About 50-50, I'd say.

HJR
> Release 2 - Rename in place
>
Received on Sun May 19 2002 - 14:23:48 CDT