Oracle 视图 ALL_CUBES 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图ALL_CUBES用于显示当前用户所有的多维分析(OLAP)立方体,存储在数据库中。
用法:
SELECT * FROM all_cubes;
这将显示当前用户的所有OLAP立方体的信息,包括立方体的名称,表空间,角色等。
例如:
SELECT *
FROM all_cubes
WHERE cube_name LIKE ‘STRAT_CUBE%’;
这将显示所有以“STRAT_CUBE”开头的OLAP立方体的信息。
官方英文解释
ALL_CUBES
describes the OLAP cubes accessible to the current user.
Related Views
DBA_CUBES
describes all OLAP cubes in the database.USER_CUBES
describes the OLAP cubes owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
| Owner of the cube | |
|
|
| Name of a cube, such as |
|
|
| ID of a cube |
|
| Name of the analytic workspace that contains the cube, such as | |
|
| Default aggregation rules for the cube | |
|
| Description of the cube in the session language | |
|
| Text value indicating the type of sparsity for the OLAP cube | |
|
| Condition syntax representing the precompute condition of the OLAP cube | |
|
| Percentage of aggregate data values that are calculated and stored during data maintenance. If the cube is partitioned, then this percentage is for the bottom partitions. | |
|
| Percentage of aggregate data values in the top partition that are calculated and stored during data maintenance | |
|
| Name of the dimension used to partition the cube, such as | |
|
| Name of the dimension hierarchy used to partition the cube, such as | |
|
| Name of the level used to partition the cube, such as | |
|
| Name of the refresh materialized view for the OLAP cube | |
|
| Name of the rewrite materialized view for the OLAP cube | |
|
| The default build specification for the OLAP cube | |
|
| The measure storage for the OLAP cube. Possible values:
| |
|
| The SQL cube storage type for the OLAP cube. This value represents a SQL data type. | |
|
| The cube storage type for the OLAP cube. This value represents a DML data type. |
See Also:
“DBA_CUBES”
“USER_CUBES”