Table of Contents Previous Next


3 Oracle Catalog Views : 3.50 DBA_TAB_PARTITIONS

The 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.
1 for the first partition; 2 for the second partition, etc.
Same as pg_class.reltuples.
Same as pg_class.relpages.

3 Oracle Catalog Views : 3.50 DBA_TAB_PARTITIONS

Table of Contents Previous Next