Re: partition table help

Have you tried 'dba_segments' ? There is a
partition_name column, which you can use to group by.

select segment_name, partition_name, sum(bytes)
from dba_segments
where segment_name = <your table name>
group by segment_name, partition_name

I am not sure how it would treat CLOB/BLOB.

Thanks,
Deepak

--- Joe Smith <joe_dba@xxxxxxxxxxx> wrote:

> How do I determine the space used by a partitioned
> table?  The traditional 
> tablespace scripts (i.e. dba_tablespaces,
> dba_data_files, dba_free_space, 
> ...) don't seem to be reporting accurately.
> 
> I have one partitioned table that contains CLOB and
> BLOB with "storage in 
> row" defined.  There is only 13 columns in the
> table.  The table is range 
> partitioned into 16 partitions.  Each partition is
> contained within its own 
> tablespace.
> 
> Every time I run a query against the table it says
> it is 90% full.  In one 
> instance I have 7 records in the table and in
> another instance I have 165 
> records in the table.  Both are relatively new
> instances for testing.
> 
> I have looked on metalink and I can see is a FAQ on
> partitioned tables for 8 
> and 8i.  Is there a site with more information on
> partitioned tables and how 
> to determine space used?
> 
> thanks.
> 
>
_________________________________________________________________
> Don?t just search. Find. Check out the new MSN
> Search! 
>
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: