如何在 Oracle 12c 中列出 PDB 和 CDB 的列表?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/36957919/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-19 03:14:01  来源:igfitidea点击:

How to list down the list of PDB and CDB in Oracle 12c?

oracleoracle12c

提问by user1535147

What is the SQL command to return a list of PDB and CDB in Oracle?

Oracle中返回PDB和CDB列表的SQL命令是什么?

回答by thatjeffsmith

DBA_PDBS views will list you the pluggable databases and their current state. PDB$SEED will be listed, but it's not one of your pluggable databases, not one that you would worry about anyway.

DBA_PDBS 视图将列出可插入数据库及其当前状态。PDB$SEED 将被列出,但它不是您的可插入数据库之一,无论如何您都不会担心。