Thanks Hiten..

This is what i see from my database....
****************************************
[Email Address Removed] *FROM dba_free_space where tablespace_name = 'USERS';

TABLESPACE_NAME FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
--------------- -------- -------- ------ ------ ------------
USERS 8 20641 66846720 8160 8

***********************************************************

How to tell how many Extents are used and how many are available ?...

Thanks
Ron



"Negandhi, Hiten" <[Email Address Removed] 'Ron Krockett' <[Email Address Removed] "LazyDBA.com Discussion"
><[Email Address Removed] RE: How to find the Extents availble/used
>Date: Fri, 28 Feb 2003 09:21:14 -0500
>
>for used extents,
>SELECT *
>FROM dba_extents
>where segment_name = '<object_name>'
>
>for free space,
>SELECT *
>FROM dba_free_space
>where tablespace_name = '<tablespace_name>'
>
>
>-----Original Message-----
>From: Ron Krockett [mailto:[Email Address Removed] Friday, February 28, 2003 9:10 AM
>To: LazyDBA.com Discussion
>Subject: How to find the Extents availble/used
>
>
>
>Hello all..
>
>Oracle 9.2
>
>How do i find out how many Extents are used /Availble in a Tablespace and
>also in a Table ?...
>
>I would greatly appreciate it.
>
>Thanks
>Ron
>
>
>
>
>_________________________________________________________________
>MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
>http://join.msn.com/?page=features/virus
>
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html


_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail

Oracle LazyDBA home page