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

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 17 Nov 1999 17:37:23 +0800
Message-ID: <38327753.7AA6@yahoo.com>

Steve Adams wrote:
>
> 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.
> >>
> >

I was wondering when you were going to include that little snippet :-) --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Nov 17 1999 - 03:37:23 CST