重庆思庄Oracle、Redhat认证学习论坛

标题: 从pdb$seed创建一个 pdb [打印本页]

作者: 郑全 时间: 2019-2-10 00:06
标题: 从pdb$seed创建一个 pdb
我们准备从种子库创建一个新的pdb crm

1.查看当前pdb情况

SQL> show pdbs
CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 ERP                         READ WRITE NO

2.创建一个新的pdb

SQL> create pluggable database crm
   admin user crmadm identified by oracle
   FILE_NAME_CONVERT=('pdbseed','crm')
   ;
Pluggable database created.

3.验证

SQL> show pdbs
CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 ERP                         READ WRITE NO
      4 CRM                         MOUNTED

crm已经创建成功。

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)