Re: Howto change/delete a column name without drop table?

From: Satar <satar_at_my-dejanews.com>
Date: Mon, 08 Feb 1999 16:57:39 GMT
Message-ID: <79n51v$7qu$1@nnrp1.dejanews.com>

In article <36BDBFDE.8E6AFBA_at_mail.gte.net>, Albert Zhu <lzhu_at_mail.gte.net> wrote:
> Hi,
>
> I am looking for a way in sqlplus to change/delete a column name. The
> ALTER TABLE seems can not do that. And I can not drop the table
> because it is tied to too many other tables.
>
> Any help is very appreciated.
>
> Albert
>
>

You cannot change or drop a column in Oracle. You have to wait till Oracle 8i comes out.

Regards,
Satar
Oracle DBA/UNIX System Admin
"Opinions are the result of the voices in my head only, and do not reflect my employer or Oracle Corporation."

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 08 1999 - 10:57:39 CST