查看pdbs
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
Switching to the PDB
SQL> alter session set container=orclpdb;
Switching to the Root
SQL> alter session set container=cdb$root;
Switching to the Seed
SQL> alter session set container=pdb$seed;
开启关闭pdb
在root下
SQL> alter pluggable database orclpdb close;
插接式数据库已变更。
SQL> alter pluggable database orclpdb open;
插接式数据库已变更。
或者切换到pdb下
SQL> alter database close;
插接式数据库已变更。
SQL> alter database open;
插接式数据库已变更。