Oracle 12c 基本操作-CDB与PDB 之间的相互切换

1.查看pdb

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO

2.切换到pdb

SQL> alter session set container=ORCLPDB;

Session altered.

3切换回CDB

SQL> alter session set container=CDB$ROOT;

Session altered.

 

posted @ 2019-07-26 10:20  彦祚  阅读(4178)  评论(0编辑  收藏  举报