DB_TAB_SUBPARTITIONS

DB_TAB_SUBPARTITIONS displays information about level-2 partitioned tables accessible to the current user. It is accessible to all users. This view exists in both PG_CATALOG and SYS schema.

**Table 1** DB_TAB_SUBPARTITIONS columns
Name	Type	Description
table_owner	character varying(64)	Table owner.
table_name	character varying(64)	Relational table name.
partition_name	character varying(64)	Partition name.
subpartition_name	character varying(64)	Name of a level-2 partition.
high_value	text	Limit of a level-2 partition. For range partitioning and interval partitioning, the upper limit of each partition is displayed. For list partitioning, the value list of each partition is displayed. For hash partitioning, the number of each partition is displayed.
tablespace_name	name	Tablespace name of a level-2 partitioned table.
schema	character varying(64)	Name of a namespace.
high_value_length	integer	Character length of the limit of a level-2 partition.
partition_position	numeric	Position of the partition in the table.
subpartition_position	numeric	Position of the level-2 partition in the partition.
pct_free	numeric	Minimum percentage of available space in a block.
pct_used	numeric	Not supported. Its value is NULL.
ini_trans	numeric	Initial number of transactions. The default value is 4. The value is NULL for non-Ustore partitioned tables.
max_trans	numeric	Maximum number of transactions. The default value is 128. The value is NULL for non-Ustore partitioned tables.
initial_extent	numeric	Not supported. Its value is NULL.
next_extent	numeric	Not supported. Its value is NULL.
min_extent	numeric	Not supported. Its value is NULL.
max_extent	numeric	Not supported. Its value is NULL.
max_size	numeric	Not supported. Its value is NULL.
pct_increase	numeric	Not supported. Its value is NULL.
freelists	numeric	Not supported. Its value is NULL.
freelist_groups	numeric	Not supported. Its value is NULL.
logging	character varying(3)	Specifies whether changes to a table are logged.
compression	character varying(8)	Actual compression attribute of a partitioned table.
compress_for	character varying(30)	Not supported. Its value is NULL.
num_rows	numeric	Number of rows in a level-2 partition.
blocks	numeric	Not supported. Its value is NULL.
empty_blocks	numeric	Not supported. Its value is NULL.
avg_space	numeric	Not supported. Its value is NULL.
chain_cnt	numeric	Not supported. Its value is NULL.
avg_row_len	numeric	Not supported. Its value is NULL.
sample_size	numeric	Not supported. Its value is NULL.
last_analyzed	timestamp with time zone	Last date when the partition was analyzed.
buffer_pool	character varying(7)	Buffer pool of a level-2 partition.
flash_cache	character varying(7)	Not supported. Its value is NULL.
cell_flash_cache	character varying(7)	Not supported. Its value is NULL.
global_stats	character varying(3)	Not supported. Its value is NULL.
user_stats	character varying(3)	Not supported. Its value is NULL.
interval	character varying(3)	Specifies whether the partition is a partition in an interval partitioned table.
segment_created	character varying(3)	Specifies whether a segment is created in a level-2 partitioned table.
indexing	character varying(3)	Not supported. Its value is NULL.
read_only	character varying(3)	Not supported. Its value is NULL.
inmemory	character varying(8)	Not supported. Its value is NULL.
inmemory_priority	character varying(8)	Not supported. Its value is NULL.
inmemory_distribute	character varying(15)	Not supported. Its value is NULL.
inmemory_compression	character varying(17)	Not supported. Its value is NULL.
inmemory_duplicate	character varying(13)	Not supported. Its value is NULL.
inmemory_service	character varying(12)	Not supported. Its value is NULL.
inmemory_service_name	character varying(1000)	Not supported. Its value is NULL.
cellmemory	character varying(24)	Not supported. Its value is NULL.
memoptimize_read	character varying(8)	Not supported. Its value is NULL.
memoptimize_write	character varying(8)	Not supported. Its value is NULL.