本站中文解释
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