ADM_PART_TABLES
ADM_PART_TABLES displays information about all partitioned tables in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. 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 a partitioned table. |
partitioning_type |
text |
Partitioning policy of a 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 a partitioned table. |
partitioning_key_count |
integer |
Number of partition keys of a partitioned table. |
def_tablespace_name |
name |
Tablespace name of a partitioned table. |
schema |
character varying(64) |
Schema of a 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.
NOTE:
For details about the supported partitioning policies of the current level-2 partitioned table, see CREATE TABLE SUBPARTITION. |
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. |
subpartitioning_key_count |
integer |
Number of level-2 partition keys of the partitioned table. |
status |
character varying(8) |
Not supported. The 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. The options are as follows:
|
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_parameter = value } [, ... ] ). |
def_buffer_pool |
character varying(7) |
Not supported. The 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 |
text |
Specifies whether to enable the automatic extension function for the level-1 list partition.
|
interval_subpartition |
character varying(1000) |
Not supported. Its value is NULL. |
autolist_subpartition |
text |
Specifies whether to enable the automatic extension function for the level-2 list partition.
|
is_nested |
character varying(3) |
Not supported. The value is NO. |
def_segment_creation |
character varying(4) |
Currently, the segment-page mode is not supported. When the segment-page mode is enabled, the value is YES. |
def_indexing |
character varying(3) |
Not supported. The value is ON. |
def_inmemory |
character varying(8) |
Not supported. The 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. The 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
