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_CUBESdescribes all OLAP cubes in the database. -
USER_CUBESdescribes the OLAP cubes owned by the current user. This view does not display theOWNERcolumn.
| 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”
