Message-Id: <10722.125326@fatcity.com> From: Alex Hillman Date: Tue, 26 Dec 2000 11:23:37 -0500 Subject: 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@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 ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" Sent: Tuesday, December 26, 2000 8:40 AM Sorry, slip of the finger, you must specify the index name, >>> "Ruth Gramolini" 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" 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 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 _______________________________________________________________ Do You Yahoo!? Consiga gratis su direcci=F3n @yahoo.es en http://correo.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =3D?iso-8859-1?q?Pablo=3D20ksksksk?=3D INET: p_rodri99@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@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@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@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@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@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@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@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@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@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 RE: When to rebuild Indexes

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@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

----- Original Message -----
To: "Multiple recipients of list ORACLE-L" = <ORACLE-L@fatcity.com>
Sent: Tuesday, December 26, 2000 8:40 AM


Sorry, slip of the finger, you must specify the index = name,

>>> "Ruth Gramolini" = <rgramolini@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@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@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



_______________________________________________________________=
Do You Yahoo!?
Consiga gratis su direcci=F3n @yahoo.es en http://correo.yahoo.es
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: = =3D?iso-8859-1?q?Pablo=3D20ksksksk?=3D
  INET: p_rodri99@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@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@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@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@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@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@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@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: Rahul Dandekar
  INET: orcldba@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@fatcity.com (note EXACT spelling of =