oracle 12c pdb与cdb

一、概念

CDB的组件：

  Root：即CDB$ROOT，保存了元数据及通用用户。如PL/SQL包的源码就是元数据。通用用户是指每一个容器都知道的数据库用户。

  The root,namedCDB$ROOT, stores Oracle-supplied metadata andcommon users. An example ofmetadata is the source code for Oracle-suppliedPL/SQL packages. A common useris a database user known in every Container. ACDB has exactly one root.

  Seed：即PDB$SEED，它是创建PDB的模板，我们不能添加或修改Seed中的对象，并且一个CDB只能有一个Seed。

  The seed, namedPDB$SEED, is a templatethat you can use to create new PDBs. You cannot add objectsto or modifyobjects in the seed. A CDB has exactly one seed.

  PDBs：一个PDB对于用户或应用程序来说就像一个普通的数据库。

  A PDB appears tousers and applications asif it were a non-CDB.

  common user与local user：

  一个CDB支持多个common user。Commonuser 在root与PDB中具有相同的标识，并且可以登录root与任何其拥有权限的PDB。Commonuser能够执行的操作取决于对common user的授权。另外，一些管理操作，如创建PDB，拔出PDB等需要由commonuser来执行。一个local user只存在于一个PDB中。

  A CDB supportscommon users. A common useris a user that has the same identity in the root andin every existing andfuture PDB. A common user can log in to the root and anyPDB in which it hasprivileges. The operations that a common user can performdepend on theprivileges granted to the common user. Some administrative tasks,such ascreating a PDB or unplugging a PDB, must be performed by a common user.A CDBalso supports local users. A local user is a user that exists in exactlyone PDB