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