MY_PART_TABLES
MY_PART_TABLES displays information about partitioned tables accessible to the current user. This view exists in both PG_CATALOG and SYS schema.
|
Name |
Type |
Description |
|---|---|---|
|
table_owner |
character varying(64) |
Owner name of a partitioned table. |
|
table_name |
character varying(64) |
Name of the partitioned table. |
|
partitioning_type |
text |
Partitioning policy of the partitioned table.
NOTE:
For details about the supported partitioning policies of the current partitioned table, see CREATE TABLE PARTITION. |
|
partition_count |
bigint |
Number of partitions of the partitioned table. |
|
partitioning_key_count |
integer |
Number of partition keys of the partitioned table. |
|
def_tablespace_name |
name |
Tablespace name of the partitioned table. |
|
schema |
character varying(64) |
Schema of the partitioned table. |
|
subpartitioning_type |
text |
Partitioning policy of a level-2 partitioned table. If the partitioned table is a level-1 partitioned table, NONE is displayed. The distributed system does not support level-2 partitions. Set this parameter to NONE. |
|
def_subpartition_count |
integer |
Default number of level-2 partitions to be created. The value is 1 for a level-2 partitioned table and 0 for a level-1 partitioned table. The distributed system does not support level-2 partitions. Set this parameter to 0. |
|
subpartitioning_key_count |
integer |
Number of level-2 partition keys of the partitioned table. The distributed system does not support level-2 partitions. Set this parameter to 0. |
|
status |
character varying(8) |
Not supported. Its value is valid. |
|
def_pct_free |
numeric |
Default value of PCTFREE used when a partition is added. |
|
def_pct_used |
numeric |
Not supported. Its value is NULL. |
|
def_ini_trans |
numeric |
Default value of INITRANS used when a partition is added. |
|
def_max_trans |
numeric |
Default value of MAXTRANS used when a partition is added. |
|
def_initial_extent |
character varying(40) |
Not supported. Its value is NULL. |
|
def_next_extent |
character varying(40) |
Not supported. Its value is NULL. |
|
def_min_extents |
character varying(40) |
Not supported. Its value is NULL. |
|
def_max_extents |
character varying(40) |
Not supported. Its value is NULL. |
|
def_max_size |
character varying(40) |
Not supported. Its value is NULL. |
|
def_pct_increase |
character varying(40) |
Not supported. Its value is NULL. |
|
def_freelists |
numeric |
Not supported. Its value is NULL. |
|
def_freelist_groups |
numeric |
Not supported. Its value is NULL. |
|
def_logging |
character varying(7) |
Not supported. Its value is NULL. |
|
def_compression |
character varying(8) |
Default compression mode used when a partition is added. Value range:
|
|
def_compress_for |
character varying(30) |
Default compression mode used when a partition is added.
NOTE:
For available compression modes and compression levels, see WITH ( { storage_paramet... |
|
def_buffer_pool |
character varying(7) |
Not supported. Its value is DEFAULT. |
|
def_flash_cache |
character varying(7) |
Not supported. Its value is NULL. |
|
def_cell_flash_cache |
character varying(7) |
Not supported. Its value is NULL. |
|
ref_ptn_constraint_name |
character varying(128) |
Not supported. Its value is NULL. |
|
interval |
character varying(1000) |
Interval. |
|
autolist |
character varying(3) |
Not supported. Its value is NO. |
|
interval_subpartition |
character varying(1000) |
Not supported. Its value is NULL. |
|
autolist_subpartition |
character varying(3) |
Not supported. Its value is NO. |
|
is_nested |
character varying(3) |
Not supported. Its value is NO. |
|
def_segment_creation |
character varying(4) |
Currently, the segment page mode is not supported. When the segment page mode is enabled, set it to YES. |
|
def_indexing |
character varying(3) |
Not supported. Its value is ON. |
|
def_inmemory |
character varying(8) |
Not supported. Its value is NONE. |
|
def_inmemory_priority |
character varying(8) |
Not supported. Its value is NULL. |
|
def_inmemory_distribute |
character varying(15) |
Not supported. Its value is NULL. |
|
def_inmemory_compression |
character varying(17) |
Not supported. Its value is NULL. |
|
def_inmemory_duplicate |
character varying(13) |
Not supported. Its value is NULL. |
|
def_read_only |
character varying(3) |
Not supported. Its value is NO. |
|
def_cellmemory |
character varying(24) |
Not supported. Its value is NULL. |
|
def_inmemory_service |
character varying(12) |
Not supported. Its value is NULL. |
|
def_inmemory_service_name |
character varying(1000) |
Not supported. Its value is NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
