Re: Oracle Help: Changing Column Names

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1997/01/26
Message-ID: <32EBE9AB.4616@qrcsun.qrc.org>#1/1

john messina wrote:

> I've also tried duplicating the table, copying
> over the data and then droping the original table.
> Unfortunately, I can not drop the original table since
> I have several tables who have foreign keys which originate
> in the table I'm currrently trying to drop.

You need to drop the referential constraints at the first time. Then drop the old table and re-create the table with the new column name. Finally, enable the referential constraints again.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

Received on Sun Jan 26 1997 - 00:00:00 CST