SYS_PARTITIONS

Information on table partitions.

Column name	Data type	Contents
TABLE_SCHEMA	CHAR (31)	Name of the schema to which the partitioned table belongs
TABLE_NAME	CHAR (31)	Name of the partitioned table
SERIAL_NUMBER	SMALLINT	Sequence number of the partition
MAX_KEY_VALUE	VARCHAR (32000)	Comparison for the upper partition boundary as specified in the VALUE clause (external presentation)
MAX_NUMBER_ OF_ROWS	INTEGER	Maximum possible number of records in the partition
SPACE_NAME	CHAR (18)	Name of the space in which the partition is stored
SPACE_ID	SMALLINT	Identification number of the space in which the partition is stored
TABLE_ID	SMALLINT	Space-related identification number of the partitioned table
ROW_ID_PREFIX	SMALLINT	Prefix to determine the row number

Table 120: SYS_PARTITIONS view of the SYS_INFO_SCHEMA