Re: Tool to drop Columns

[Quoted] Why not just do

1) CREATE new_table AS SELECT col1, col3, colN FROM old_table;
2) DROP TABLE old_table;
3) RENAME new_table TO old_table;

Be sure to backup first.
- Dan Clamage

Bill Smith <bill_at_frameworkinc.com> wrote in article <3443834F.275D82AA_at_frameworkinc.com>...
> Does anyone have, or know of a tool or utility that enables you to
> easily drop column(s) from an oracle table?
Received on Wed Oct 15 1997 - 00:00:00 CEST