Re: Puzzling Tablespace

From: <shelbyko_at_my-dejanews.com>
Date: Fri, 07 May 1999 14:03:17 GMT
Message-ID: <7gurr2$7nr$1@nnrp1.deja.com>

Initial extent can be set per object (index in your case). So it is quite possible that the indexes in the Tablespace have different initial extents.

In article <3732DF8E.EFF56B8F_at_capgemini.co.uk>, Alex Hudghton <alex.hudghton_at_capgemini.co.uk> wrote:
> Forgot
>
> Oracle 7.3.4
> Sequent DYNIX/ptx 4
>
> Alex Hudghton wrote:
>
> > I have a tablespace for indexes consisting of 6 datafiles. If I query
> > DBA_SEGMENTS I get 19 rows returned showing various values for the
> > initial extent. If I limit this query by DISTINCT I get 8 rows returned.
> > Why? Surely I should get 6 rows or less (only 1 if initial extent was
> > the same for all datafiles.
> >
> > Can someone explain this please!
> >
> > Regards
> >
> > Alex
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 09:03:17 CDT