MY_PART_TABLES
MY_PART_TABLES displays information about partitioned tables accessible to the current user. This view exists in the PG_CATALOG and SYS schemas.
| 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 | Partition 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 | Partition 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. Set it to valid. |
| def_pct_free | numeric | Default value of PCTFREE used when a partition is added. |
| def_pct_used | numeric | Not supported. Set it to 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. Set it to NULL. |
| def_next_extent | character varying(40) | Not supported. Set it to NULL. |
| def_min_extents | character varying(40) | Not supported. Set it to NULL. |
| def_max_extents | character varying(40) | Not supported. Set it to NULL. |
| def_max_size | character varying(40) | Not supported. Set it to NULL. |
| def_pct_increase | character varying(40) | Not supported. Set it to NULL. |
| def_freelists | numeric | Not supported. Set it to NULL. |
| def_freelist_groups | numeric | Not supported. Set it to NULL. |
| def_logging | character varying(7) | Not supported. Set it to 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. Set it to DEFAULT. |
| def_flash_cache | character varying(7) | Not supported. Set it to NULL. |
| def_cell_flash_cache | character varying(7) | Not supported. Set it to NULL. |
| ref_ptn_constraint_name | character varying(128) | Not supported. Set it to NULL. |
| interval | character varying(1000) | Interval. |
| autolist | character varying(3) | Not supported. Set it to NO. |
| interval_subpartition | character varying(1000) | Not supported. Set it to NULL. |
| autolist_subpartition | character varying(3) | Not supported. Set it to NO. |
| is_nested | character varying(3) | Not supported. Set it to 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. Set it to ON. |
| def_inmemory | character varying(8) | Not supported. Set it to NONE. |
| def_inmemory_priority | character varying(8) | Not supported. Set it to NULL. |
| def_inmemory_distribute | character varying(15) | Not supported. Set it to NULL. |
| def_inmemory_compression | character varying(17) | Not supported. Set it to NULL. |
| def_inmemory_duplicate | character varying(13) | Not supported. Set it to NULL. |
| def_read_only | character varying(3) | Not supported. Set it to NO. |
| def_cellmemory | character varying(24) | Not supported. Set it to NULL. |
| def_inmemory_service | character varying(12) | Not supported. Set it to NULL. |
| def_inmemory_service_name | character varying(1000) | Not supported. Set it to NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
