Help Center > > Developer Guide> System Catalogs and System Views> System Views> USER_IND_PARTITIONS

USER_IND_PARTITIONS

Updated at:Jul 15, 2020 GMT+08:00

USER_IND_PARTITIONS displays information about index partitions accessible to the current user.

Table 1 USER_IND_PARTITIONS columns

Name

Type

Description

index_owner

character varying(64)

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

schema

character varying(64)

Schema of the partitioned table index to which the index partition belongs

index_name

character varying(64)

Index name of the partitioned table index 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

Upper limit of the partition corresponding to the index partition

def_tablespace_name

name

Tablespace name of the index partition

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel