Re: Number of partitions on a table?

Since your solution is the same as the FIRST one posted for this question where how do you justify your ignorant and flippant remarks? Until you posted nothing but correct answers had been provided, and all of them minus the idiotic commentary.

Should you ever increase your reading comprehension to a level where you can understand the text before you let us know. Until then, your needless and, yes, stupid, comments are not welcome.

David Fitzjarrell

ntareen_at_yahoo.com (Nisar Tareen) wrote in message news:<6134f1ca.0411031303.1d997a0b_at_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 Thu Nov 04 2004 - 07:59:43 CST