Column Name | Data Type | Description |
table_name | char(256) | The name of the partitioned table |
table_owner | char(32) | The owner of the table |
dimension | smallint | The dimension being described, counting from 1 |
logical_partseq | smallint | The logical partition sequence number in its dimension, counting from 1 |
partition_name | char(256) | The name of the partition If no name is assigned in the partition definition, a name of the form iipartNN is used, where NN is a sequence number. |
value_sequence | smallint | The partitioning value being described: RANGE then incremental from 1 LIST then incremental from 1 AUTOMATIC then one entry with a zero value_sequence HASH then one entry with a zero value_sequence |
column_sequence | smallint | The column component in the partitioning value: RANGE then incremental from 1 LIST then incremental from 1 AUTOMATIC then one entry with a zero column_sequence HASH then one entry with a zero column_sequence |
operator | varchar(7) | If the partitioning is based on: RANGE then <, <=, =, >=, > LIST then =, DEFAULT AUTOMATIC then blank HASH then blank |
value | varchar (1500) | If the partitioning is based on: RANGE then column value LIST then column value (if DEFAULT, then meaningless) AUTOMATIC then NULL HASH then NULL |