Renaming columns ??

From: <cavenewt_at_my-dejanews.com>
Date: Fri, 13 Nov 1998 15:24:02 GMT
Message-ID: <72hiui$7ti$1@nnrp1.dejanews.com>

In article <364BE33E.2C8E_at_bhp.com.au>,
Connor McDonald <mcdonald.connor.cs_at_bhp.com.au> wrote:
> Dr. Jan Dieckmann wrote:
> >
> > No, you can't drop or rename a column in Oracle. But there are some
> > tools which will do all the work (create a new table, copy the data,
> > create the indexes, foreign keys ...) for you. Look at
> > ftp:\\www.keeptool.com. You can download a free trial version of the
> > Oracle tool Hora 3.
> >

A friend of mine recently logged in as sys, and modified the catalog to 'apparently' rename a column. It appeared to work (superficially). Has anyone else tried this? What are the ramifications of doing this?

(Please e-mail a reply)

--
http://www.nethole.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 13 1998 - 09:24:02 CST