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 GuideOracle Database Security
Guide
编辑:广州明生医药有限公司
标签:数据,容器,数据库,视图,数据库中