3.77 USER_TAB_PARTITIONSThe USER_TAB_PARTITIONS view provides information about all of the partitions that are owned by the current user.
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.