At 04:40 PM 2/23/00 -0600, Ross J. Reedstrom wrote:
>"Adding a column to a relational database table seldom breaks
>queries. Until Oracle 8.1.5, you weren't able to drop a column."
>
>My guess would be that Oracle found out internally what we've been
>discussing here: doing DROP COLUMN right is _hard_.
They ended up providing both kinds of drop that have been discussed
here, i.e. a slow one that actually mucks through the table getting
rid of physical data, and a quick one that simply marks the column
as being invisible resulting in it being ignored in the future.
- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.