Oracle 视图 ALL_CUBE_SUB_PARTITION_LEVELS 官方解释，作用，如何使用详细说明
本站中文解释
ALL_CUBE_SUB_PARTITION_LEVELS视图是Oracle数据库用于提取和比较全部Cube Subpartition级别的元数据信息的视图。此视图描述Cube Subpartition的属性，包括位置和深度，以及数据文件的信息。
它可以用来查询当前用户所拥有的Cube Subpartitions的所有元数据信息；可以用来检查Cube Subpartition是否存在，以及检查Cube Subpartition的属性、大小、深度、索引是否正确；也可以将其与ALL_PARTITIONS视图连接起来查询Cube Subpartition的级别。
使用ALL_CUBE_SUB_PARTITION_LEVELS视图的方法如下：
1.查询所有元数据信息：SELECT * FROM ALL_CUBE_SUB_PARTITION_LEVELS;
2.检查某个Cube Subpartition的属性：SELECT * FROM ALL_CUBE_SUB_PARTITION_LEVELS WHERE CUBE_SUBPARTITION_NAME=’subpartition_name’;
3.检查某个Cube Subpartition是否存在：SELECT COUNT(1) FROM ALL_CUBE_SUB_PARTITION_LEVELS WHERE CUBE_SUBPARTITION_NAME=’subpartition_name’;
4.将其与ALL_PARTITIONS视图连接起来查询Cube Subpartition的级别：SELECT a.partition_level, b.subpartition_level FROM all_partitions a, all_cube_sub_partition_levels b WHERE a.partition_name=b.cube_subpartition_name;
官方英文解释
ALL_CUBE_SUB_PARTITION_LEVELS describes the OLAP secondary partition levels in the database that are accessible by the user.
Related Views
DBA_CUBE_SUB_PARTITION_LEVELSdescribes the OLAP secondary partition levels in the database.USER_CUBE_SUB_PARTITION_LEVELSdescribes the OLAP secondary partition levels in the database that are owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
| Owner of the OLAP secondary partition level | |
|
| Name of the OLAP cube | |
|
| Name of the secondary partition level of the OLAP cube | |
|
| Precompute percent of the secondary partition level of the OLAP cube | |
|
| Name of the cube dimension for which there is a secondary partition level on the OLAP cube | |
|
| Name of the hierarchy for which there is a secondary partition level on the OLAP cube | |
|
| Name of the hierarchy level for which there is a secondary partition level on the OLAP cube | |
|
| Order number of the secondary partition level on the OLAP cube |
See Also:
“DBA_CUBE_SUB_PARTITION_LEVELS”
“USER_CUBE_SUB_PARTITION_LEVELS”
编辑：编程语言
标签：视图,数据,将其,信息,属性