Oracle教程

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_INDEXES displays the object-level partitioning information for all partitioned indexes in the database.

  • USER_PART_INDEXES displays the object-level partitioning information for the partitioned indexes owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the partitioned index

INDEX_NAME

VARCHAR2(128)

NOT NULL

Name of the partitioned index

TABLE_NAME

VARCHAR2(128)

NOT NULL

Name of the partitioned table

PARTITIONING_TYPE

VARCHAR2(9)

Type of the partitioning method:

  • NONE – Not specified

    See Also: the *_INDEXES view

  • RANGE

  • HASH

  • SYSTEM

  • LIST

  • REFERENCE

SUBPARTITIONING_TYPE

VARCHAR2(9)

Type of the composite partitioning method:

  • NONE – Not specified

    See Also: the *_INDEXES view

  • RANGE

  • HASH

  • SYSTEM

  • LIST

  • REFERENCE

PARTITION_COUNT

NUMBER

NOT NULL

Number of partitions in the index

DEF_SUBPARTITION_COUNT

NUMBER

For a composite-partitioned index, the default number of subpartitions, if specified

PARTITIONING_KEY_COUNT

NUMBER

NOT NULL

Number of columns in the partitioning key

SUBPARTITIONING_KEY_COUNT

NUMBER

For a composite-partitioned index, the number of columns in the subpartitioning key

LOCALITY

VARCHAR2(6)

Indicates whether the partitioned index is local (LOCAL) or global (GLOBAL)

ALIGNMENT

VARCHAR2(12)

Indicates whether the partitioned index is prefixed (PREFIXED) or non-prefixed (NON_PREFIXED)

DEF_TABLESPACE_NAME

VARCHAR2(30)

For a local index, the default tablespace to be used when adding or splitting a table partition

DEF_PCT_FREE

NUMBER

NOT NULL

For a local index, the default PCTFREE value to be used when adding a table partition

DEF_INI_TRANS

NUMBER

NOT NULL

For a local index, the default INITRANS value to be used when adding a table partition

DEF_MAX_TRANS

NUMBER

NOT NULL

For a local index, the default MAXTRANS value to be used when adding a table partition

DEF_INITIAL_EXTENT

VARCHAR2(40)

For a local index, the default INITIAL value (in Oracle blocks) to be used when adding a table partition, or DEFAULT if no INITIAL value was specified

DEF_NEXT_EXTENT

VARCHAR2(40)

For a local index, the default NEXT value (in Oracle blocks) to be used when adding a table partition, or DEFAULT if no NEXT value was specified

DEF_MIN_EXTENTS

VARCHAR2(40)

For a local index, the default MINEXTENTS value to be used when adding a table partition, or DEFAULT if no MINEXTENTS value was specified

DEF_MAX_EXTENTS

VARCHAR2(40)

For a local index, the default MAXEXTENTS value to be used when adding a table partition, or DEFAULT if no MAXEXTENTS value was specified

DEF_MAX_SIZE

VARCHAR2(40)

For a local index, the default MAXSIZE value to be used when adding a table partition, or DEFAULT if no MAXSIZE value was specified

DEF_PCT_INCREASE

VARCHAR2(40)

For a local index, the default PCTINCREASE value to be used when adding a table partition, or DEFAULT if no PCTINCREASE value was specified

DEF_FREELISTS

NUMBER

NOT NULL

For a local index, the default FREELISTS value to be used when adding a table partition

DEF_FREELIST_GROUPS

NUMBER

NOT NULL

For a local index, the default FREELIST GROUPS value to be used when adding a table partition

DEF_LOGGING

VARCHAR2(7)

For a local index, the default LOGGING attribute to be used when adding a table partition:

  • NONE – Not specified

    See Also: the *_INDEXES view

  • YES

  • NO

DEF_BUFFER_POOL

VARCHAR2(7)

For a local index, the default buffer pool to be used when adding a table partition:

  • DEFAULT

  • KEEP

  • RECYCLE

  • NULL

DEF_FLASH_CACHE

VARCHAR2(7)

For a local index, the default Database Smart Flash Cache hint to be used when adding a table partition:

  • DEFAULT

  • KEEP

  • NONE

Solaris and Oracle Linux functionality only.

DEF_CELL_FLASH_CACHE

VARCHAR2(7)

For a local index, the default cell flash cache hint to be used when adding a table partition:

  • DEFAULT

  • KEEP

  • NONE

See Also: Oracle Exadata Storage Server Software documentation for more information

DEF_PARAMETERS

VARCHAR2(1000)

Default parameter string for domain indexes

INTERVAL

VARCHAR2(1000)

String of the interval value

AUTOLIST

VARCHAR2(3)

Indicates whether a local index is partitioned by auto list partitioning (YES) or not (NO)

INTERVAL_SUBPARTITION

VARCHAR2(1000)

String of the subpartition interval value

AUTOLIST_SUBPARTITION

VARCHAR2(3)

Indicates whether a local index is subpartitioned by auto list partitioning (YES) or not (NO)

See Also:

  • “DBA_PART_INDEXES”

  • “USER_PART_INDEXES”


数据运维技术 » Oracle 视图 ALL_PART_INDEXES 官方解释，作用，如何使用详细说明
分享到：

相关推荐