Re: Index rebuilding behavior

Strange behaviour, this. I've yet to see an object that is not partitioned span tablespaces. Can you provide the statement you're running and the output from it?

Pete

skubiszewski_at_Eisner.DECUS.Org wrote:

> In article <7ocl5d$n5v$1_at_nnrp1.deja.com>, Tim_Cuthbertson_at_sonat.com writes:
> >In article <FFyG1o.DEp_at_news.decus.org>,
> > skubiszewski_at_Eisner.DECUS.Org wrote:
> >> [snip]
> >> How does rebuild work?
> >>
> >> Rose
> >>
> >
> >I am sorry, but I cannot understand what you are describing. An index
> >is a segment, and a segment can only have extents in one tablespace
> >(unless it is a partioned index in Oracle 8 +). Is it a partitioned
> >index?
>
> I'm using Oracle v7.3.4. If I query the extents that comprise the
> index, I see 24 total, in various sizes and tablespaces.
>
> After I issue an "alter index <name> rebuild storage (initial xxx
> next xxx pctincrease 0) tablespace yyy", I see 6 extents, in various
> sizes and tablespaces for the index.
>
> I expected extents of size xxx in tablespace yyy but that's not
> what happened and I'm curious why. Rebuild does not appear to
> honor the storage clause?
>
> Rose

--
Regards

Pete

Received on Wed Aug 11 1999 - 10:44:25 CDT