| 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: When to rebuild Indexes
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_01C06F58.333EFFB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
It is good advice for version 7. Beginning with 8 oracle rebuilds in =
the
same tablespace. Of cource if you need to move index to another =
tablespace
you shpuld use tablspace clouse.
Alex Hillman
-----Original Message-----
From: Rahul Dandekar [mailto:orcldba_at_hotmail.com]
Sent: Tuesday, December 26, 2000 11:00 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: When to rebuild Indexes
I would recommend adding tablespace name... to keep it in same = tablespace.
'alter index schema.my_index rebuild tablespace tablespace_name;'
Am I right in saying that in case the tablespace is not given then the =
index
is recreated in the default tablespace of the user....
-Rahul
Sorry, slip of the finger, you must specify the index name,
>>> "Ruth Gramolini" <rgramolini_at_tax.state.vt.us> 12/22/00 07:56AM >>> I believe the command it 'alter index schema.my_index rebuild;'
Ruth
it is more important to be human than to be important
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Thursday, December 21, 2000 4:03 PM
In version 7.3 and above tablespaces are automatically coalesced, but =
if you
mean to defragment the index, use the
alter index schema.my_table rebuild
Which will recreate the index by reading the previous index. You can =
also
change the storage sizes and tablespace if you want to during the =
rebuild.
The default is to rebuild with the same storage and tablespace as the
previous index.
>>> Pablo ksksksk <p_rodri99_at_yahoo.es> 12/21/00 02:50PM >>> Hi list:
I'd like to know when should I colaesce an index?
When should I rebuild it?
What views should I be looking at?
thank you
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =3D?iso-8859-1?q?Pablo=3D20ksksksk?=3D INET: p_rodri99_at_yahoo.es 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: BeilstWH_at_OBG.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: rgramolini_at_tax.state.vt.us 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: BeilstWH_at_OBG.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). --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20 Author: Rahul Dandekar INET: orcldba_at_hotmail.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_01C06F58.333EFFB0 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: When to rebuild Indexes</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>It is good advice for version 7. Beginning with 8 = oracle rebuilds in the same tablespace. Of cource if you need to move = index to another tablespace you shpuld use tablspace clouse.</FONT></P> <P><FONT SIZE=3D2>Alex Hillman</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Rahul Dandekar [<A = HREF=3D"mailto:orcldba_at_hotmail.com">mailto:orcldba_at_hotmail.com</A>]</FON= T> <BR><FONT SIZE=3D2>Sent: Tuesday, December 26, 2000 11:00 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: When to rebuild Indexes</FONT> </P> <BR> <P><FONT SIZE=3D2>I would recommend adding tablespace name... to keep = it in same tablespace.</FONT> </P> <P><FONT SIZE=3D2>'alter index schema.my_index rebuild tablespace = tablespace_name;'</FONT> </P> <P><FONT SIZE=3D2>Am I right in saying that in case the tablespace is = not given then the index</FONT> <BR><FONT SIZE=3D2>is recreated in the default tablespace of the = user....</FONT> </P> <BR> <P><FONT SIZE=3D2>-Rahul</FONT> </P> <P><FONT SIZE=3D2>----- Original Message -----</FONT> <BR><FONT SIZE=3D2>To: "Multiple recipients of list ORACLE-L" = <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>Sent: Tuesday, December 26, 2000 8:40 AM</FONT> </P> <BR> <P><FONT SIZE=3D2>Sorry, slip of the finger, you must specify the index = name,</FONT> </P> <P><FONT SIZE=3D2>>>> "Ruth Gramolini" = <rgramolini_at_tax.state.vt.us> 12/22/00 07:56AM >>></FONT> <BR><FONT SIZE=3D2>I believe the command it 'alter index = schema.my_index rebuild;'</FONT> </P> <P><FONT SIZE=3D2>Ruth</FONT> <BR><FONT SIZE=3D2>it is more important to be human than to be = important</FONT> <BR><FONT SIZE=3D2>----- Original Message -----</FONT> <BR><FONT SIZE=3D2>To: "Multiple recipients of list ORACLE-L" = <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>Sent: Thursday, December 21, 2000 4:03 PM</FONT> </P> <BR> <P><FONT SIZE=3D2>In version 7.3 and above tablespaces are = automatically coalesced, but if you</FONT> <BR><FONT SIZE=3D2>mean to defragment the index, use the</FONT> </P> <P><FONT SIZE=3D2>alter index schema.my_table rebuild</FONT> </P> <P><FONT SIZE=3D2>Which will recreate the index by reading the previous = index. You can also</FONT> <BR><FONT SIZE=3D2>change the storage sizes and tablespace if you want = to during the rebuild.</FONT> <BR><FONT SIZE=3D2>The default is to rebuild with the same storage and = tablespace as the</FONT> <BR><FONT SIZE=3D2>previous index.</FONT> </P> <P><FONT SIZE=3D2>>>> Pablo ksksksk <p_rodri99_at_yahoo.es> = 12/21/00 02:50PM >>></FONT> <BR><FONT SIZE=3D2>Hi list:</FONT> </P> <P><FONT SIZE=3D2>I'd like to know when should I colaesce an = index?</FONT> </P> <P><FONT SIZE=3D2>When should I rebuild it?</FONT> <BR><FONT SIZE=3D2>What views should I be looking at?</FONT> </P> <P><FONT SIZE=3D2>thank you</FONT> </P> <BR> <BR> <P><FONT = SIZE=3D2>_______________________________________________________________= </FONT> <BR><FONT SIZE=3D2>Do You Yahoo!?</FONT> <BR><FONT SIZE=3D2>Consiga gratis su direcci=F3n @yahoo.es en <A = HREF=3D"http://correo.yahoo.es" = TARGET=3D"_blank">http://correo.yahoo.es</A></FONT> <BR><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Author: = =3D?iso-8859-1?q?Pablo=3D20ksksksk?=3D</FONT> <BR><FONT SIZE=3D2> INET: p_rodri99_at_yahoo.es</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 =Received on Tue Dec 26 2000 - 10:23:37 CST
'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>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Author: William Beilstein</FONT> <BR><FONT SIZE=3D2> INET: BeilstWH_at_OBG.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> <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>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Author: Ruth Gramolini</FONT> <BR><FONT SIZE=3D2> INET: rgramolini_at_tax.state.vt.us</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> <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>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Author: William Beilstein</FONT> <BR><FONT SIZE=3D2> INET: BeilstWH_at_OBG.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> <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>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Rahul Dandekar</FONT> <BR><FONT SIZE=3D2> INET: orcldba_at_hotmail.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 =
 |
 |