Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Puzzling Tablespace
Hi,
Dba_segments gives you varius segment info like
table,cluster,index,temp,rollback etc.
If you want to see the data files use view v$datafile.You can also join
them with v$tablespace using TS# common column.
FYI :There will be no storage parameters for datafiles.
Alex Hudghton wrote in message <3732DE28.24A9E35F_at_capgemini.co.uk>...
>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 - 09:48:03 CDT