Updated on 2023-04-14 GMT+08:00

DBA_IND_PARTITIONS

DBA_IND_PARTITIONS displays information about all index partitions in the database. Each index partition of a partitioned table in the database, if present, has a row of records in DBA_IND_PARTITIONS. This view is accessible only to users with system administrator rights.

Name

Type

Description

index_owner

character varying(64)

Name of the owner of the partitioned index to which the index partition belongs

schema

character varying(64)

Schema of the partitioned index to which the index partition belongs

index_name

character varying(64)

Index name of the partitioned table to which the index partition belongs

partition_name

character varying(64)

Name of the index partition

index_partition_usable

boolean

Whether the index partition is available

high_value

text

Boundary of the table partition corresponding to the index partition. For a range partition, the boundary is the upper boundary. For a list partition, the boundary is the boundary value set.

Reserved field for forward compatibility. The parameter pretty_high_value is added in version 8.1.3 to record the information.

pretty_high_value

text

Boundary of the table partition corresponding to the index partition. For a range partition, the boundary is the upper boundary. For a list partition, the boundary is the boundary value set.

The query result is the instant decompilation output of the partition boundary expression. The output of this column is more detailed than that of high_value. The output information can be collation and column data type.

def_tablespace_name

name

Tablespace name of the index partition