3.50 DBA_TAB_PARTITIONSThe DBA_TAB_PARTITIONS view provides information about all of the partitions that reside in the database.
YES if the table is subpartitioned; NO if the table is not subpartitioned. The high partitioning value specified in the CREATE TABLE statement. 1 for the first partition; 2 for the second partition, etc. Same as pg_class.reltuples. Same as pg_class.relpages.