代码改变世界

Oracle 12C -- 不同容器之间切换

2015-11-01 15:44  abce  阅读(1309)  评论(0)    收藏  举报

1.使用connect

SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT
SQL> connect sys@pdb1 as sysdba
Enter password: 
Connected.
SQL> show con_name

CON_NAME
------------------------------
PDB1
SQL>

2.使用alter session

SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT
SQL> alter session set container=pdb1;

Session altered.

SQL> show con_name;

CON_NAME
------------------------------
PDB1
SQL>