Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Number of partitions on a table?
debashish_majumdar_at_rediffmail.com (debashish) wrote in
news:bb05cfc5.0411020603.2afa752a_at_posting.google.com:
> 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'; Received on Tue Nov 02 2004 - 08:49:04 CST
![]() |
![]() |