Number of partitions on a table?

[Database Administrator]

Hello
How can one know the number of partitions on a table?

Thanks in advance
Debashish

[Database Administrator]

debashish_majumdar@rediffmail.com (debashish) wrote in
news:bb05cfc5.0411020603.2afa752a@posting.google.c om:

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

select count(*) from dba_part_table where table_name = 'FOO_TABLE';

[Database Administrator]

debashish_majumdar@rediffmail.com (debashish) wrote in
news:bb05cfc5.0411020603.2afa752a@posting.google.c om:

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

select count(*) from dba_part_table where table_name = 'FOO_TABLE';

[Database Administrator]

debashish_majumdar@rediffmail.com (debashish) wrote in
news:bb05cfc5.0411020603.2afa752a@posting.google.c om:

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

select count(*) from dba_part_table where table_name = 'FOO_TABLE';

[Database Administrator]

debashish_majumdar@rediffmail.com (debashish) wrote in
news:bb05cfc5.0411020603.2afa752a@posting.google.c om:

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

select count(*) from dba_part_table where table_name = 'FOO_TABLE';

[Database Administrator]

debashish_majumdar@rediffmail.com (debashish) wrote in
news:bb05cfc5.0411020603.2afa752a@posting.google.c om:

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

select count(*) from dba_part_table where table_name = 'FOO_TABLE';

[Database Administrator]

debashish_majumdar@rediffmail.com (debashish) wrote in
news:bb05cfc5.0411020603.2afa752a@posting.google.c om:

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

select count(*) from dba_part_table where table_name = 'FOO_TABLE';

[Database Administrator]

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@x.washington.edu
(replace 'x' with 'u' to respond)

[Database Administrator]

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@x.washington.edu
(replace 'x' with 'u' to respond)

[Database Administrator]

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@x.washington.edu
(replace 'x' with 'u' to respond)