Re: Index rebuilding behavior

In article <934405153.22464.0.nnrp-13.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> writes:
>It seems you have two indexes of the same name.
>Try selecting the owner with the rest of the segment name
>to find out who owns the index that has been built in the
>V_IDS_INDEX tablespace.

Who'd have thunk it? You are correct!
I didn't consider that two schemas would use the exact same index name, which was rather unique to begin with.

>I am slightly puzzled by the 320K extent, because I would
>thought Oracle only grabbed extra fragments if this stopped
>a free extent of LESS THAN 5 blocks being left behind - it
>looks from your example as if that should be LESS THAN OR
>EQUAL TO 5 blocks - I'll have to check that.

The rebuilt index is in the tablespace I requested, it has 5 extents, 4 of size 280K, 1 of size 320K and I can't explain why. Pctincrease is 0.

Rose Received on Thu Aug 12 1999 - 14:54:37 CDT