Updated on 2024-06-03 GMT+08:00

DB_PART_TABLES

DB_PART_TABLES displays information about partitioned tables accessible to the current user. This view exists in the PG_CATALOG and SYS schemas.

Table 1 DB_PART_TABLES columns

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 in the distributed system.

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 in the distributed system.

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:
  • NONE - Not specified
  • ENABLED
  • DISABLED

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.