Re: How to rename a column name?

From: Karen Abgarian <karen.abgarian_at_fmr.com>
Date: Wed, 15 Sep 1999 10:02:55 -0400
Message-ID: <37DFA70F.F9223B53@fmr.com>

I think Oracle does not support changing of column names because it does not record column dependencies. You may change the column names directly in sys.col$ but ensure that no view or stored procedure references the changed column(s). After the change flush the shared pool or even reboot the server.

I would not do it in any mission critical or production database, unless it is extremely necessary. And if you do, dont tell it to Oracle Support, they will reference it for every other problem you have.

Regards,
Karen Abgarian.

wy3141_at_my-deja.com wrote:

> I want to change the column name,and I don't want to drop it and
> recreate it. Because it has some dependencies(role right,constraints)
> on it.
> Can Oracle support change the column name directly?
> Any suggestion are helpful.
> Thanks in advance.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Wed Sep 15 1999 - 09:02:55 CDT