USER_IND_PARTITIONS displays information about index partitions accessible to the current user.
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) |
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 |
Name of the tablespace of the index partition |