| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Alter table drop column question in 8i
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C00494.77370DD0
Content-Type: text/plain;
charset="iso-8859-1"
How large was your database, what version and what platform? I dropped columns many times on 8.1.6 Linux and Solaris on a small (2G) database from tables which were not analyzed and did not see any adverse effects.
Alex Hillman
-----Original Message-----
From: Terry Ball [mailto:terry_ball_at_csgsystems.com]
Sent: Friday, July 28, 2000 5:38 PM
To: Multiple recipients of list ORACLE-L
Subject: 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).
-- Author: Terry Ball INET: terry_ball_at_csgsystems.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). ------_=_NextPart_001_01C00494.77370DD0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Alter table drop column question in 8i</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>How large was your database, what version and what = platform? I dropped columns many times on 8.1.6 Linux and Solaris on a = small (2G) database from tables which were not analyzed and did not see = any adverse effects.</FONT></P> <P><FONT SIZE=3D2>Alex Hillman</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Terry Ball [<A = HREF=3D"mailto:terry_ball_at_csgsystems.com">mailto:terry_ball_at_csgsystems.c= om</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Friday, July 28, 2000 5:38 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: Alter table drop column question in = 8i</FONT> </P> <BR> <P><FONT SIZE=3D2>One thing we have found (the hard way). You = need to analyze the</FONT> <BR><FONT SIZE=3D2>table in question before you drop the column. = We haven't noticed</FONT> <BR><FONT SIZE=3D2>much difference dropping one column as opposed to = multiple</FONT> <BR><FONT SIZE=3D2>columns, but we have had the database freeze if the = table was</FONT> <BR><FONT SIZE=3D2>not analyzed.</FONT> </P> <P><FONT SIZE=3D2>Terry</FONT> </P> <P><FONT SIZE=3D2>"Oak, Sameer" wrote:</FONT> </P> <P><FONT SIZE=3D2>> Gurus</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> I would like to drop 4 columns from a table = with 100 million rows.</FONT> <BR><FONT SIZE=3D2>> Is there any advice/ suggestion or some hints = to make this faster???</FONT> <BR><FONT SIZE=3D2>> ( I am thinking this will take some hours for = sure.)</FONT> <BR><FONT SIZE=3D2>> Any side effects????</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> TIA</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Sameer</FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Author: Oak, Sameer</FONT> <BR><FONT SIZE=3D2>> INET: soak_at_ziptone.com</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information (like subscribing).</FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Terry Ball</FONT> <BR><FONT SIZE=3D2> INET: terry_ball_at_csgsystems.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT>Received on Sat Aug 12 2000 - 14:35:26 CDT
 |
 |