December 2002
Intermediate to advanced
928 pages
85h 29m
English
The following views provide information about partitioned tables and indexes:
Lists all index partitions. One row exists for each index partition.
Contains distribution information about partitioned columns that have been analyzed—for example, *_TAB_COL_STATISTICS for partitioned tables.
Contains information about histograms created on individual partitions.
Lists all partitioned indexes. One row exists for each index partition.
Lists the partition key columns for all partitions.
Lists all partitioned tables. One row exists for each partitioned table.
Lists all table partitions. One row exists for each table partition.