Oracle 视图 ALL_ANALYTIC_VIEWS 官方解释,作用,如何使用详细说明
本站中文解释
Oracle 视图ALL_ANALYTIC_VIEWS是Oracle数据库中提供的一种内置集合视图,包含了所有已安装的Analytic视图的信息。
用途:使用ALL_ANALYTIC_VIEWS视图可以获取系统中Analytic视图的信息,包括:视图的作用域、创建者、安装时间、安装用户和授权语句等相关信息。
使用方法:可以使用SELECT语句在ALL_ANALYTIC_VIEWS视图中查询所需要的信息,如使用如下语句可以查询已安装的Analytic视图:
SELECT *
FROM all_analytic_views;
官方英文解释
ALL_ANALYTIC_VIEWS
describes the analytic views accessible to the current user.
Related Views
-
DBA_ANALYTIC_VIEWS
describes all analytic views in the database. -
USER_ANALYTIC_VIEWS
describes the analytic views owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the analytic view |
|
|
|
Name of the analytic view |
|
|
|
Owner of the fact table or view on which the analytic view is defined |
|
|
|
Name of the fact table or view on which the analytic view is defined |
|
|
Alias of the fact table or view on which the analytic view is defined; the default is |
|
IS_REMOTE Foot 1 |
VARCHAR2(1) |
Indicates whether the source is a remote table. The values are:
|
|
|
|
Default aggregation of the analytic view |
|
DEFAULT_AGGR_GROUP_NAME Foot 1 |
|
|
Always |
|
|
Name of the default measure of the analytic view |
|
|
|
Compile status of the analytic view:
|
|
DYN_ALL_CACHE |
VARCHAR2(1) |
The value of this column is always |
|
QUERY_TRANSFORM_ENABLED Foot 1 |
VARCHAR2(1) |
Indicates whether query transformation is enabled for the analytic view ( |
|
QUERY_TRANSFORM_RELY Foot 1 |
VARCHAR2(1) |
Indicates whether the |
|
|
|
The ID of the container where the data originates. Possible values include:
|
Footnote 1 This column is available starting with Oracle Database 21c.
See Also:
-
“DBA_ANALYTIC_VIEWS”
-
“USER_ANALYTIC_VIEWS”