MY_TAB_SUBPARTITIONS

MY_TAB_SUBPARTITIONS displays information about all level-2 partitioned tables accessible to the current user, including level-2 partition names, names of the tables and partitions to which the level-2 partitions belong, their storage attributes, and statistics generated by the DBMS_STATS package. This view can be accessed by all users. Only the information about the current user can be viewed. This view exists in both PG_CATALOG and SYS schema.

**Table 1** MY_TAB_SUBPARTITIONS columns
Name	Type	Description
table_owner	character varying(64)	Table owner.
schema	character varying(64)	Specifies the schema name.
table_name	character varying(64)	Table name.
partition_name	character varying(64)	Partition name.
subpartition_name	character varying(64)	Name of a level-2 partition.
high_value	text	Binding value expression in a level-2 partition.
high_value_length	integer	Length of the binding value expression in 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.
tablespace_name	name	Name of the tablespace where the level-2 partition is located.
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.
max_trans	numeric	Maximum number of transactions.
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(7)	Specifies whether changes to a table are logged. YES NO
compression	character varying(8)	Specifies whether a subpartition is compressed. Value range: ENABLED and DISABLED.
compress_for	character varying(30)	Not supported. Its value is NULL.
num_rows	numeric	Not supported. Its value is NULL.
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	Date when the table was last analyzed. Database restart is not supported. Otherwise, data loss will occur.
buffer_pool	character varying(7)	Buffer pool of a level-2 partition. DEFAULT KEEP RECYCLE NULL
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 in the interval section of an interval partitioned table (YES) or whether the partition is in the range section (NO).
segment_created	character varying(3)	Specifies whether the level-2 partition segment of the table has been created. YES: created. NO: not created. N/A: The table does not have level-2 partitions.
indexing	character varying(3)	Not supported. Its value is NULL.
read_only	character varying(5)	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.