Oracle Database 12c创建Pluggable Database的两种方式及拔出、插入、删除Pluggable Database

dbca建库后的目录结构（包括一个CDB,10个PDB）:

[root@db-12c tree-1.6.0]# tree /opt/oracle/oradata

/opt/oracle/oradata

`-- cdb

    |-- control01.ctl

    |-- pdb1

    |   |-- pdb1_users01.dbf

    |   |-- sysaux01.dbf

    |   |-- system01.dbf

    |   `-- temp01.dbf

    |-- pdb10

    |   |-- pdb10_users01.dbf

    |   |-- sysaux01.dbf

    |   |-- system01.dbf

    |   `-- temp01.dbf

    |-- pdb2

    |   |-- pdb2_users01.dbf

    |   |-- sysaux01.dbf

    |   |-- system01.dbf

    |   `-- temp01.dbf

    |-- pdb3

    |   |-- pdb3_users01.dbf

    |   |-- sysaux01.dbf

    |   |-- system01.dbf

    |   `-- temp01.dbf

    |-- pdb4

    |   |-- pdb4_users01.dbf

    |   |-- sysaux01.dbf

    |   |-- system01.dbf

    |   `-- temp01.dbf

    |-- pdb5

    |   |-- pdb5_users01.dbf

    |   |-- sysaux01.dbf

    |   |-- system01.dbf

    |   `-- temp01.dbf

    |-- pdb6

    |   |-- pdb6_users01.dbf

    |   |-- sysaux01.dbf

    |   |-- system01.dbf

    |   `-- temp01.dbf

    |-- pdb7

    |   |-- pdb7_users01.dbf

    |   |-- sysaux01.dbf

    |   |-- system01.dbf

    |   `-- temp01.dbf

    |-- pdb8

    |   |-- pdb8_users01.dbf

    |   |-- sysaux01.dbf

    |   |-- system01.dbf

    |   `-- temp01.dbf

    |-- pdb9

    |   |-- pdb9_users01.dbf

    |   |-- sysaux01.dbf

    |   |-- system01.dbf

    |   `-- temp01.dbf

    |-- pdbseed

    |   |-- pdbseed_temp01.dbf

    |   |-- sysaux01.dbf

    |   `-- system01.dbf

    |-- redo01.log

    |-- redo02.log

    |-- redo03.log

    |-- sysaux01.dbf

    |-- system01.dbf

    |-- temp01.dbf

    |-- undotbs01.dbf

    `-- users01.dbf

 

*****************************从seed创建PDB mypdb1：**************************************************

 

SQL>CREATE PLUGGABLE DATABASE mypdb1 admin user lexidentified by oracle

  2  STORAGE (MAXSIZE2G MAX_SHARED_TEMP_SIZE 100M)

  3  DEFAULT TABLESPACE lex datafile'/opt/oracle/oradata/cdb/mypdb1/lex.dbf' size 100M

  4  PATH_PREFIX ='/opt/oracle/oradata/cdb/mypdb1/'

  5  FILE_NAME_CONVERT = ('/opt/oracle/oradata/cdb/pdbseed/','/opt/oracle/oradata/cdb/mypdb1/');

 

Pluggable databasecreated.

 

[root@db-12c tree-1.6.0]# tree /opt/oracle/oradata

/opt/oracle/oradata

`-- cdb

    |-- control01.ctl

    |-- mypdb1

    |   |-- lex.dbf

    |   |-- pdbseed_temp01.dbf