If you have fragmented tablespace or extents in the
same tablespace with different sizes then i think it
would be better to first build the indexes in a
different tablespace and then move it to the original
one. In this way you can have a pretty packed
tablespace without any fragmentation.
Thanks
Abhimanyu
- Alex Hillman <alex_hillman_at_physia.com> wrote:
> 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-----
> Sent: Tuesday, December 26, 2000 11:00 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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_at_fatcity.com>
> Sent: Tuesday, December 26, 2000 8:40 AM
>
>
> 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
>
>
>
>
> Do You Yahoo!?
> Consiga gratis su dirección @yahoo.es en
> http://correo.yahoo.es
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Pablo=20ksksksk?=
> 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).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> 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
Received on Wed Dec 27 2000 - 07:17:27 CST