Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Can Oracle drop a column?

Can Oracle drop a column?

From: Yao Fang <fangyao_at_worldnet.att.net>
Date: 1997/05/25
Message-ID: <01bc68e2$7c957b00$af3293cf@bfang>#1/1 







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
Received on Sun May 25 1997 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US