Oracle 视图 ALL_ATTRIBUTE_DIM_TABLES_AE 官方解释,作用,如何使用详细说明
本站中文解释
ALL_ATTRIBUTE_DIM_TABLES_AE(Oracle属性维度表的所有视图)是Oracle中元数据视图。它用于查询所有已经创建的维度表。所有者可以在此视图中检查已经创建的表,并找出相关信息,例如:表的创建日期,维度表的行数,维度表的来源和包括的列等。 使用此视图,可以查询每个表的操作系统,表的保护类别,元数据的类型,以及访问用户等信息。
ALL_ATTRIBUTE_DIM_TABLES_AE视图可以以以下方式使用:
SELECT T.TABLE_NAME, T.DIMENSE_COUNT, T.CREATED_DATE
FROM dba_tables T
JOIN ALL_ATTRIBUTE_DIM_TABLES_AE D
ON T.TABLE_NAME=D.TABLE_NAME;
此查询用于检索表名,维度表的行数和创建日期。
官方英文解释
ALL_ATTRIBUTE_DIM_TABLES_AE
describes the tables used by the attribute dimensions (across all editions) accessible to the current user.
Related Views
-
DBA_ATTRIBUTE_DIM_TABLES_AE
describes the tables used by all attribute dimensions (across all editions) in the database. -
USER_ATTRIBUTE_DIM_TABLES_AE
describes the tables used by the attribute dimensions (across all editions) owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of table used by the attribute dimension |
|
|
|
Name of the attribute dimension |
|
|
|
Owner of the table or view used by the attribute dimension |
|
|
|
Name of the table or view used by the attribute dimension |
|
|
Alias specified for the table or view; if not specified, the name of the table or view |
|
IS_REMOTE |
|
Indicates whether the source is a remote table. The values are:
|
|
|
|
|
Order of the table in the list of tables in the |
|
|
The ID of the container where the data originates. Possible values include:
|
|
|
|
Name of the application edition where the attribute dimension is defined |
Note:
This view is available starting with Oracle Database release 21c, version 21.5.
See Also:
-
“DBA_ATTRIBUTE_DIM_TABLES_AE”
-
“USER_ATTRIBUTE_DIM_TABLES_AE”