Partitioning
These views provide information about partitioned tables and indexes:
- DBA_IND_PARTITIONS
Lists all index partitions. There is one row for each index partition.
- DBA_PART_COL_STATISTICS
Contains distribution information about partitioned columns that have been analyzed; comparable to DBA_TAB_COL_STATISTICS for partitioned tables.
- DBA_PART_HISTOGRAMS
Contains information about histograms created on individual partitions.
- DBA_PART_INDEXES
Lists all partitioned indexes. There is one row for each partitioned index.
- DBA_PART_KEY_COLUMNS
Lists the partition key columns for all partitions.
- DBA_PART_TABLES
Lists all partitioned tables. There is one row for each partitioned table.
- DBA_TAB_PARTITIONS
Lists all table partitions. There is one row for each table partition.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.