Re: Oracle #1? Then why are these still missing...

Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:37a90280.21331683_at_newshost.us.oracle.com...
> A copy of this was sent to killer796_at_yahoo.com
> (if that email address didn't require changing)
> On Fri, 30 Jul 1999 18:53:57 GMT, you wrote:
>
> >Um, I'm glad like you guys have a forum to vent your rage. Better here
> >than on the highway. But do you think maybe you could turn your 200
> >collective years of experience to answering some oracle questions. I
> >posted one this morning (Renaming Columns 8i) and there has been no
> >solutions posted from any of you eminent experts.
> >
>
> can't answer the impossible (actually, if you read this thread -- you'd
know
> that you cannot rename a column :)
>
> rename of a column doesn't exist.
>

I believe that in Oracle 8i you can create a new column, copy the contents of the old column into the new column, and drop the old column. You'll have to amend any indexes belonging to the old column, and any views, and any constraints and code.

You could try using a tool like DB Artisan to generate code for the renaming of a column. This will crank out code automatically, for all the constraints, indexes etc, and it's relatively cheap as Oracle tools go.

It won't, however, deal with amending code. I don't know of anything that can do this, except major human intervention! However, and impact analysis tool can help to tell you which code to change. We use SQL*Impact, which is not, alas, cheap.

Simon Hedges
Gloucester
UK Received on Sat Jul 31 1999 - 12:52:56 CDT