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 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 |
See Also: