Re: Alter table drop column question in 8i

One thing we have found (the hard way). You need to analyze the table in question before you drop the column. We haven't noticed much difference dropping one column as opposed to multiple columns, but we have had the database freeze if the table was not analyzed.

Terry

"Oak, Sameer" wrote:

> Gurus
>
> I would like to drop 4 columns from a table with 100 million rows.
> Is there any advice/ suggestion or some hints to make this faster???
> ( I am thinking this will take some hours for sure.)
> Any side effects????
>
> TIA
>
> Sameer
> --
> Author: Oak, Sameer
> INET: soak_at_ziptone.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Jul 28 2000 - 15:19:09 CDT