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

I wish it were that simple...but no, the default storage parameters are 480K uniform extent sizes. It's just deciding to allocate 11 instead of 1 for each partition.

*Sigh*

I've even tried specifying the sizes in the rebuild statement.

Maybe I'll just leave that one index in the data tablespace...

Thanks,
Diana

-----Original Message-----
From: Tom Pall [mailto:tom_at_cdproc.com]
Sent: Wednesday, November 01, 2000 5:01 PM To: Multiple recipients of list ORACLE-L Subject: 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? Received on Thu Nov 02 2000 - 08:19:45 CST