Monday, September 16, 2013

Oracle Database 12c - Create PDB

Create New Pluggable database

SQL> CREATE PLUGGABLE DATABASE dx12p ADMIN USER pdb_adm IDENTIFIED BY pdb_adm FILE_NAME_CONVERT=('/oradisk/oradata/dx12c/pdbseed/','/oradisk/oradata/dx12c/dx12p/');

Pluggable database created.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 DX12P                          MOUNTED

No comments:

Post a Comment