使用 show pdbs 可以确认当前有哪些PDB?
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBORCL MOUNTED
4 PDBTESTDB READ WRITE NO
查看当前所在的容器
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
检查一个db是不是cdb
SQL> select DBID,NAME,OPEN_MODE,CDB,CON_ID from v$database;
DBID NAME OPEN_MODE CDB CON_ID
---------- --------- -------------------- --- ----------
1580043057 ORCL READ WRITE YES 0
查看当前cdb中pdb的信息
SQL> select name,open_mode from v$pdbs;
NAME