Re: Can I rename a colum name w/oracle 8i?

Hi All,

I should also have mentioned, just in case there are any novices looking on, that this is "unsupported". Updating the data dictionary directly can get your database into a VERY messy state if you make a mistake, and Oracle Support will not help you fix it.

Regards,
Steve Adams

http://www.ixora.com.au/

http://www.oreilly.com/catalog/orinternals/

http://www.christianity.com.au/

On Tue, 16 Nov 1999 22:39:52 GMT, steve.adams_at_ixora.com.au (Steve Adams) wrote:

>Hello Mark,
>
>It is possible to update the data dictionary directly. However, it is
>a little involved if the table if referred to in any stored PL/SQL
>code. There is something on my web site (1st URL below) about this.
>Search for "rename column".
>
>Regards,
>Steve Adams
>http://www.ixora.com.au/
>http://www.oreilly.com/catalog/orinternals/
>http://www.christianity.com.au/
>
>
>On Tue, 16 Nov 1999 13:08:56 +0100, Mark Berry <mark_at_somm.com> wrote:
>
>>
>> I installed the Linux version of Oracle 8i.
>>
>>Doesn't seem that I can alter the name of a colum that I created?..
>>thanks.
>>
>
Received on Tue Nov 16 1999 - 18:54:15 CST