Updated on 2024-05-07 GMT+08:00

DB_PART_TABLES

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

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 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.

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 a partitioned table.

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:
  • NONE
  • 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_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, the value is 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.