Check dba_segments, it will have all of the information you need.

Mike
[Email Address Removed] Original Message -----
From: <trace.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, October 31, 2002 10:09 AM
Subject: partition query help


> does anyone have a query that will give me the size of each partition (and
> possibly number of extents) for each partition in table and associated
> index?
>
> TRJ
>
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit 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
>
Oracle LazyDBA home page