Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Howto change/delete a column name without drop table?
a simpler way of doing this is just to create a copy of the table minus the
field you want to delete and then drop the old table
Satar wrote in message <79n51v$7qu$1_at_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 Sat Feb 13 1999 - 21:03:23 CST