Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

On this page

Show all

DBA_PART_TABLES

Updated on 2023-10-31 GMT+08:00

DBA_PART_TABLES displays information about all partitioned tables in the database. It is accessible only to users with system administrator rights.

Name

Type

Description

table_owner

character varying(64)

Name of the owner of the partitioned table

schema

character varying(64)

Schema of the partitioned table

table_name

character varying(64)

Name of the partitioned table

partitioning_type

text

Partition policy of the partitioned table

NOTE:

Currently, only range partitioning and list partitioning are supported.

partition_count

bigint

Number of partitions of the partitioned table

def_tablespace_name

name

Tablespace name of the partitioned table

partitioning_key_count

integer

Number of partition keys of the partitioned table

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback