Re: Number of partitions on a table?

From: Nisar Tareen <ntareen_at_yahoo.com>
Date: 3 Nov 2004 13:03:03 -0800
Message-ID: <6134f1ca.0411031303.1d997a0b@posting.google.com>

Lot of acadamic on this group" Too may words less solution... WOW....

Dabashish...

To check the details about the Partition table , Check the contents of View
DBA_PART_TABLES. By the way mention your oracle version with your questions it will help in answering the question.

Nisar Tareen

DA Morgan <damorgan_at_x.washington.edu> wrote in message news:<1099465123.601593_at_yasure>...
> 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
Received on Wed Nov 03 2004 - 15:03:03 CST