三、Oracle12c_PDB的拔插与删除

这里简单介绍了拔出PDB，删除PDB，插入PDB的操作方法：

1、unplug PDB

查看PDB信息：

SQL> select name,open_mode from v$pdbs;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDB_1                          READ WRITE
PDB_2                          READ WRITE
PDB_3                          READ WRITE
PDB_4                          READ WRITE

SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT

拔出PDB_4（必须连接到CDB$ROOT）：

首先关闭PDB_4

SQL> alter pluggable database pdb_4 close immediate;

Pluggable database altered.

然后就可以unplug

SQL>  alter pluggable database pdb_4 unplug into '/home/oracle/unplugged_pdbs/pdb_4.xml'