Re: Number of partitions on a table?

debashish wrote:

> Hello
> How can one know the number of partitions on a table?
>
> Thanks in advance
> Debashish

dba_ind_partitions
dba_ind_subpartitions
dba_lob_partitions
dba_lob_subpartitions
dba_subpartition_templates
dba_subpart_col_statistics
dba_subpart_histograms
dba_subpart_key_columns
dba_tab_partitions
dba_tab_subpartitions

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)