An index being rebuilt changes it's extent sizes?

List,

I'm very confused. I have a partitioned index created with LOCAL into a locally managed tablespace with uniform extent sizes of 480K. When I create the index, everything is OK, except it goes into the data tablespaces where the base table is (because of the LOCAL). The extent sizes are 480K, which is 30 blocks. For reference, the statement is:

CREATE INDEX DOC_INDEX_VALUE_LOWER_STRING ON DOC_INDEX_VALUE(DOMAIN_ID, lower(string_value), INDEX_ID)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE ACCT0_INDX
STORAGE (INITIAL 480K NEXT 480K)
LOCAL
;

Then, I rebuild each partition into the associated index tablespace using a command like the following:

alter index DOC_INDEX_VALUE_LOWER_STRING rebuild partition ACCT1051 tablespace ACCT1051_INDX;

After the rebuild, the index partitions suddenly have 330 blocks rather than 30. Any idea why? This only happens with the one index out of all of them. It is a function-based index, but it isn't the only one...

Any ideas? I'm baffled. ;-)

TIA, Diana Duncan
Database Architect
filefrenzy
diana_at_filefrenzy.com Received on Wed Nov 01 2000 - 12:42:10 CST