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 -> Re: How to drop a column of a table?

Re: How to drop a column of a table?

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Wed, 03 Mar 1999 14:43:15 -0800
Message-ID: <36DDBAEC.51D32B06@us.oracle.com>


Tony

Prior to 8i, you could use a variety of tools to automate this (basically, each one copied the rows, dropped the old table, created a new one minus the column, moved the data back again, recreated necessary indexes, grants, synonyms etc.). 8i has a drop column syntax in the alter table that allows you to either reclaim the space (i.e. actually delete the data for that column) or ignore the column (thus allowing you to reclaim the space later in a maintenance window)

HTH Pete.

Tony Xu wrote:

> Is there a way to alter a table and drop one column of the table? Thanks,

--

Regards

Pete


Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)
San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA


Received on Wed Mar 03 1999 - 16:43:15 CST

Original text of this message

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