Oracle 视图 DBA_CONTAINER_DATA 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_CONTAINER_DATA是一个数据字典视图，它会提供一些关于Oracle容器数据库(CDB)和全局数据库中存储数据和元数据的信息，例如CDB和PDB的名称，数据文件类型，Tablespace，Datafiles，Memory Structure等行为。它也用于显示所有的PDB状态参数（是否可解锁，关闭等）。它的使用方法非常直接，只需要执行SELECT语句，即可从中检索有关容器数据库的信息。例如：
SELECT * FROM DBA_CONTAINER_DATA;
这将显示数据库中所有容器数据库的信息。
官方英文解释
DBA_CONTAINER_DATA displays default (user-level) and object-specific CONTAINER_DATA attributes for container data objects.
Objects created with the CONTAINER_DATA clause include CONTAINER_DATA attributes.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the user whose attribute is described by this row |
|
|
|
|
An indicator of whether the attribute is a default attribute |
|
|
|
|
Name of the object owner if the attribute is object-specific |
|
|
|
|
Name of the object if the attribute is object-specific |
|
|
|
|
An indicator of whether this attribute applies to all containers |
|
|
|
|
Name of a container included in this attribute if it does not apply to all containers |
See Also:
For more information about container data objects:
-
“CDB_* Views”
-
“ALL_TABLES”
-
“ALL_VIEWS”
-
“ALL_VIEWS_AE”
-
“V$ Views”
-
“GV$ Views”
-
Oracle Multitenant
Administrator’s Guide -
Oracle Database Security
Guide
