Re: An index being rebuilt changes it's extent sizes?

Makes perfect sense.

But you specify storage parameters when building the index, not when rebuilding the index partition. Could you be picking up default storage parameters of the index tablespace you're rebuilding into? ----- Original Message -----
From: Diana Duncan <Diana_at_fileFRENZY.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, November 01, 2000 2:21 PM Subject: RE: An index being rebuilt changes it's extent sizes?

> See below...
>
> -----Original Message-----
> Sent: Wednesday, November 01, 2000 3:08 PM
> To: ORACLE-L_at_fatcity.com; Diana_at_fileFRENZY.com
>
>
> >I am also confused.
> By me? ;-)
>
> >I have local indexes on partitioned tables, though not function-based.
>
> >When I create the local indexes they go into the tablespace where I tell
> them to go.
> >Furthermore, since I do not specify DEFAULT, when I split a partition, the
> new index
> >partitions go into the previous tablespace I built the index in.
>
> >When I issue a rebuild and specify the tablespace, the index gets rebuilt
> into the
> >tablespace I specified.
>
> So you're saying that everything works for you. Well, I don't have a
> problem with the tablespaces, exactly. Just the number of extents it's
> allocating after a rebuild. It may help you to understand that each of my
> partitions has it's own DATA and INDX tablespaces. Since the base table is
> partitioned into the DATA tablespaces, creating the index with the LOCAL
> parameter puts the partitions for the index into the DATA tablespace. At
> this point, the number of extents are correct. I then want to rebuild them
> into the individual INDX tablespaces that correspond to the partition.
> After the rebuild, all of the partitions suddenly have 11 extents instead of
> 1.
>
> Make more sense?
>
> Diana
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Diana Duncan
> INET: Diana_at_fileFRENZY.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 Wed Nov 01 2000 - 15:59:21 CST