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 the PG_CATALOG and SYS schemas. The distributed system does not support level-2 partitioned tables. All columns in this view are set to NULL.

**Table 1** DB_TAB_SUBPARTITIONS columns
Name	Type	Description
table_owner	character varying(128)	Not supported. The value is NULL.
table_name	character varying(128)	Not supported. The value is NULL.
partition_name	character varying(128)	Not supported. The value is NULL.
subpartition_name	character varying(128)	Not supported. The value is NULL.
high_value	text	Not supported. The value is NULL.
high_value_length	numeric	Not supported. The value is NULL.
partition_position	numeric	Not supported. The value is NULL.
subpartition_position	numeric	Not supported. The value is NULL.
tablespace_name	character varying(30)	Not supported. The value is NULL.
pct_free	numeric	Not supported. The value is NULL.
pct_used	numeric	Not supported. The value is NULL.
ini_trans	numeric	Not supported. The value is NULL.
max_trans	numeric	Not supported. The value is NULL.
initial_extent	numeric	Not supported. The value is NULL.
next_extent	numeric	Not supported. The value is NULL.
min_extent	numeric	Not supported. The value is NULL.
max_extent	numeric	Not supported. The value is NULL.
max_size	numeric	Not supported. The value is NULL.
pct_increase	numeric	Not supported. The value is NULL.
freelists	numeric	Not supported. The value is NULL.
freelist_groups	numeric	Not supported. The value is NULL.
logging	character varying(3)	Not supported. The value is NULL.
compression	character varying(8)	Not supported. The value is NULL.
compress_for	character varying(30)	Not supported. The value is NULL.
num_rows	numeric	Not supported. The value is NULL.
blocks	numeric	Not supported. The value is NULL.
empty_blocks	numeric	Not supported. The value is NULL.
avg_space	numeric	Not supported. The value is NULL.
chain_cnt	numeric	Not supported. The value is NULL.
avg_row_len	numeric	Not supported. The value is NULL.
sample_size	numeric	Not supported. The value is NULL.
last_analyzed	date	Not supported. The value is NULL.
buffer_pool	character varying(7)	Not supported. The value is NULL.
flash_cache	character varying(7)	Not supported. The value is NULL.
cell_flash_cache	character varying(7)	Not supported. The value is NULL.
global_stats	character varying(3)	Not supported. The value is NULL.
user_stats	character varying(3)	Not supported. The value is NULL.
interval	character varying(3)	Not supported. The value is NULL.
segment_created	character varying(3)	Not supported. The value is NULL.
indexing	character varying(3)	Not supported. The value is NULL.
read_only	character varying(3)	Not supported. The value is NULL.
inmemory	character varying(8)	Not supported. The value is NULL.
inmemory_priority	character varying(8)	Not supported. The value is NULL.
inmemory_distribute	character varying(15)	Not supported. The value is NULL.
inmemory_compression	character varying(17)	Not supported. The value is NULL.
inmemory_duplicate	character varying(13)	Not supported. The value is NULL.
inmemory_service	character varying(12)	Not supported. The value is NULL.
inmemory_service_name	character varying(1000)	Not supported. The value is NULL.
cellmemory	character varying(24)	Not supported. The value is NULL.
memoptimize_read	character varying(8)	Not supported. The value is NULL.
memoptimize_write	character varying(8)	Not supported. The value is NULL.