Oracle 视图 ALL_PART_INDEXES 官方解释，作用，如何使用详细说明
本站中文解释
Oracle中的ALL_PART_INDEXES视图主要用于查看当前用户拥有的所有表的全部分区索引的相关信息，包括索引的所属模式、表名称、分区名称、索引名称等信息。
ALL_PART_INDEXES视图仅提供以下表的只读访问：ALL_INDEXES、ALL_TABLES、ALL_PART_KEY_COLUMNS以及USER_PART_TABLES.
使用ALL_PART_INDEXES视图可以查看一个用户拥有的表的索引情况。例如，以下查询可用于返回用户拥有的表的每个分区索引的索引名称、模式名称和分区名称：
SELECT index_name, table_owner, table_name, partition_name
FROM all_part_indexes
ORDER BY table_name, index_name;
此外，还可以根据表名或索引名检索特定表分区索引的信息。例如，以下查询将返回表名称为MY_TABLE和索引名称为MY_INDEX的特定分区索引的信息：
SELECT index_name, table_owner, table_name, partition_name
FROM all_part_indexes
WHERE table_name = ‘MY_TABLE’
AND index_name = ‘MY_INDEX’;
官方英文解释
ALL_PART_INDEXES displays the object-level partitioning information for the partitioned indexes accessible to the current user.
Related Views
DBA_PART_INDEXESdisplays the object-level partitioning information for all partitioned indexes in the database.USER_PART_INDEXESdisplays the object-level partitioning information for the partitioned indexes owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
| Owner of the partitioned index |
|
|
| Name of the partitioned index |
|
|
| Name of the partitioned table |
|
| Type of the partitioning method:
| |
|
| Type of the composite partitioning method:
| |
|
|
| Number of partitions in the index |
|
| For a composite-partitioned index, the default number of subpartitions, if specified | |
|
|
| Number of columns in the partitioning key |
|
| For a composite-partitioned index, the number of columns in the subpartitioning key | |
|
| Indicates whether the partitioned index is local ( | |
|
| Indicates whether the partitioned index is prefixed ( | |
|
| For a local index, the default tablespace to be used when adding or splitting a table partition | |
|
|
| For a local index, the default |
|
|
| For a local index, the default |
|
|
| For a local index, the default |
|
| For a local index, the default | |
|
| For a local index, the default | |
|
| For a local index, the default | |
|
| For a local index, the default | |
|
| For a local index, the default | |
|
| For a local index, the default | |
|
|
| For a local index, the default |
|
|
| For a local index, the default |
|
| For a local index, the default
| |
|
| For a local index, the default buffer pool to be used when adding a table partition:
| |
|
| For a local index, the default Database Smart Flash Cache hint to be used when adding a table partition:
Solaris and Oracle Linux functionality only. | |
|
| For a local index, the default cell flash cache hint to be used when adding a table partition:
See Also: Oracle Exadata Storage Server Software documentation for more information | |
|
| Default parameter string for domain indexes | |
|
| String of the interval value | |
|
| Indicates whether a local index is partitioned by auto list partitioning ( | |
|
| String of the subpartition interval value | |
|
| Indicates whether a local index is subpartitioned by auto list partitioning ( |
See Also:
“DBA_PART_INDEXES”
“USER_PART_INDEXES”
