Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to drop a column of a table?
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