通过alter session 切换容器,开启关闭pdb

岳嘉良
2023-12-01

查看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;

插接式数据库已变更。

 

 类似资料: