Table partitioning views reference v17
Query the catalog views that are compatible with Oracle databases to review detailed information about your partitioned tables.
all_part_tables all_tab_partitions all_tab_subpartitions all_part_key_columns all_subpart_key_columns