Query the following catalog views (compatible with Oracle databases) to review detailed information about your partitioned tables.

ALL PART TABLES

The following table lists the available information in the ALL_PART_TABLES view:

Column Type Description
owner name The owner of the table.
table_name name The name of the table.
schema_name name The schema in which the table resides.
partitioning_type text RANGE or LIST
subpartitioning_type text RANGE, LIST, or NONE
partition_count bigint The number of partitions.
def_subpartition_count integer The default subpartition count. This column is set to 0.
partitioning_key_count integer The number of columns listed in the partition by clause.
subpartitioning_key_count integer The number of columns in the subpartition by clause.
status character varying(8) This column is set to VALID and provided for Oracle compatibility.
def_tablespace_name character varying(30) This column is set to NULL and provided for Oracle compatibility.
def_pct_free numeric This column is set to NULL and provided for Oracle compatibility.
def_pct_used numeric This column is set to NULL and provided for Oracle compatibility.
def_ini_trans numeric This column is set to NULL and provided for Oracle compatibility.
def_max_trans numeric This column is set to NULL and provided for Oracle compatibility.
def_initial_extent character varying(40) This column is set to NULL and provided for Oracle compatibility.
def_next_extent character varying(40) This column is set to NULL and provided for Oracle compatibility.
def_min_extents character varying(40) This column is set to NULL and provided for Oracle compatibility.
def_max_extents character varying(40) This column is set to NULL and provided for Oracle compatibility.
def_pct_increase character varying(40) This column is set to NULL and provided for Oracle compatibility.
def_freelists numeric This column is set to NULL and provided for Oracle compatibility.
def_freelist_groups numeric This column is set to NULL and provided for Oracle compatibility.
def_logging character varying(7) This column is set to YES and provided for Oracle compatibility.
def_compression character varying(8) This column is set to NONE and provided for Oracle compatibility.
def_buffer_pool character varying(7) This column is set to DEFAULT and provided for Oracle compatibility.
ref_ptn_constraint_name character varying(30) This column is set to NULL and provided for Oracle compatibility.
interval character varying(1000) This column is set to NULL and provided for Oracle compatibility.

ALL_TAB_PARTITIONS

The following table lists the available information in the ALL_TAB_PARTITIONS view:

Column Type Description
table_owner name The owner of the table.
table_name name The name of the table.
schema_name name The schema in which the table resides.
composite text This column is set to YES if the table is subpartitioned and set to NO if the table is not subpartitioned.
partition_name name The name of the partition.
subpartition_count bigint The number of subpartitions for this partition.
high_value text The partition limit for RANGE partitions, or the partition value for LIST partitions.
high_value_length integer The length of high_value.
partition_position integer The ordinal position of this partition.
tablespace_name name The table space in which this partition resides.
pct_free numeric This column is set to 0 and provided for Oracle compatibility.
pct_used numeric This column is set to 0 and provided for Oracle compatibility.
ini_trans numeric This column is set to 0 and provided for Oracle compatibility.
max_trans numeric This column is set to 0 and provided for Oracle compatibility.
initial_extent numeric This column is set to NULL and provided for Oracle compatibility.
next_extent numeric This column is set to NULL and provided for Oracle compatibility.
min_extent numeric This column is set to 0 and provided for Oracle compatibility.
max_extent numeric This column is set to 0 and provided for Oracle compatibility.
pct_increase numeric This column is set to 0 and provided for Oracle compatibility.
freelists numeric This column is set to NULL and provided for Oracle compatibility.
freelist_groups numeric This column is set to NULL and provided for Oracle compatibility.
logging character varying(7) This column is set to YES and provided for Oracle compatibility.
compression character varying(8) This column is set to NONE and provided for Oracle compatibility.
num_rows numeric The approximate number of rows in this partition.
blocks integer The approximate number of blocks in this partition.
empty_blocks numeric This column is set to NULL and provided for Oracle compatibility.
avg_space numeric This column is set to NULL and provided for Oracle compatibility.
chain_cnt numeric This column is set to NULL and provided for Oracle compatibility.
avg_row_len numeric This column is set to NULL and provided for Oracle compatibility.
sample_size numeric This column is set to NULL and provided for Oracle compatibility.
last_analyzed timestamp without time zone This column is set to NULL and provided for Oracle compatibility.
buffer_pool character varying(7) This column is set to NULL and provided for Oracle compatibility.
global_stats character varying(3) This column is set to YES and provided for Oracle compatibility.
user_stats character varying(3) This column is set to NO and provided for Oracle compatibility.
backing_table regclass The OID of the backing table for this partition.
server_name name The name of the server on which the partition resides.

ALL TAB SUBPARTITIONS

The following table lists the available information in the ALL_TAB_SUBPARTITIONS view:

Column Type Description
table_owner name The owner of the table.
table_name name The name of the table.
schema_name name The schema in which the table resides.
partition_name name The name of the partition.
high_value text The subpartition limit for RANGE subpartitions, or the subpartition value for LIST subpartitions.
high_value_length integer The length of high value.
subpartition_name name The name of the subpartition.
subpartition_position integer The ordinal position of this subpartition.
tablespace_name name The tablespace in which this partition resides.
pct_free numeric This column is set to 0 and provided for Oracle compatibility.
pct_used numeric This column is set to 0 and provided for Oracle compatibility.
ini_trans numeric This column is set to 0 and provided for Oracle compatibility.
max_trans numeric This column is set to 0 and provided for Oracle compatibility.
initial_extent numeric This column is set to NULL and provided for Oracle compatibility.
next_extent numeric This column is set to NULL and provided for Oracle compatibility.
min_extent numeric This column is set to 0 and provided for Oracle compatibility.
max_extent numeric This column is set to 0 and provided for Oracle compatibility.
pct_increase numeric This column is set to 0 and provided for Oracle compatibility.
freelists numeric This column is set to NULL and provided for Oracle compatibility.
freelist_groups numeric This column is set to NULL and provided for Oracle compatibility.
logging character varying(7) This column is set to YES and provided for Oracle compatibility.
compression character varying(8) This column is set to NONE and provided for Oracle compatibility.
num_rows numeric The approximate number of rows in this subpartition.
blocks integer The approximate number of blocks in this subpartition.
empty_blocks numeric This column is set to NULL and provided for Oracle compatibility.
avg_space numeric This column is set to NULL and provided for Oracle compatibility.
chain_cnt numeric This column is set to NULL and provided for Oracle compatibility.
avg_row_len numeric This column is set to NULL and provided for Oracle compatibility.
sample_size numeric This column is set to NULL and provided for Oracle compatibility.
last_analyzed timestamp without time zone This column is set to NULL and provided for Oracle compatibility.
buffer_pool character varying(7) This column is set to NULL and provided for Oracle compatibility.
global_stats character varying(3) This column is set to YES and provided for Oracle compatibility.
user_stats character varying(3) This column is set to NO and provided for Oracle compatibility.
backing_table regclass The OID of the backing table for this subpartition.
server_name name The name of the server on which the subpartition resides.

ALL PART KEY COLUMNS

The following table lists the available information in the ALL_PART_KEY_COLUMNS view:

Column Type Description
owner name The owner of the table.
name name The name of the table.
schema name The schema in which the table resides.
object_type character(5) This column is set to TABLE and provided for Oracle compatibility.
column_name name The name of the partition key column.
column_position integer The position of this column within the partition key. Each column has a corresponding column position (for example, the first column has a column position of 1, the second column has a column position of 2).

ALL SUBPART KEY COLUMNS

The following table lists the available information in the ALL_SUBPART_KEY_COLUMNS view.

Column Type Description
owner name The owner of the table.
name name The name of the table.
schema name The schema in which the table resides.
object_type character(5) This column is set to TABLE and provided for Oracle compatibility.
column_name name The name of the partition key column.
column_position integer The position of this column within the subpartition key. Each column has a corresponding column position (for example, the first column has a column position of 1, the second column has a column position of 2).