Re: Can Oracle drop a column?

From: Johnny Verhoeven <Johnny.Verhoeven_at_ping.be>
Date: 1997/05/25
Message-ID: <33891768.5A73@ping.be>#1/1

Yao Fang wrote:
>
> Hi there :
> The table has about 1m of data. I want to drop a column of that table.
> It seems like Oracle doesn't allow me to do that. When I use ALTER TABLE
> command. The only thing I can drop is the constraints. Some may suggest to
> create a temporary table, then use INSERT to transfer the data.(It takes
> some time) Is there any other ways?
> TIA
>
> Kathy Fangyao

You connot drop a table, the above suggested is a good way ( temp table)

Johnny Verhoeven
Technic and Technology Received on Sun May 25 1997 - 00:00:00 CDT