Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Puzzling Tablespace

Re: Puzzling Tablespace

From: Alex Hudghton <alex.hudghton_at_capgemini.co.uk>
Date: Fri, 07 May 1999 13:41:51 +0100
Message-ID: <3732DF8E.EFF56B8F@capgemini.co.uk> 





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



Received on Fri May 07 1999 - 07:41:51 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US