SYED CREATING PDB AND UNPLUGGING PDB

select instance_name, version, status from v$instance;

INSTANCE_NAME    VERSION           STATUS
---------------- ----------------- ------------
CDBTES           12.1.0.2.0        OPEN

SQL>select name,cdb from v$database;

SQL> select name,cdb from v$database;

NAME      CDB
--------- ---
CDBTES    YES



this database is container database and it supports pluugable database option



SQL> SHOW CON_NAME;

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

SQL> CREATE PLUGGABLE DATABASE pdb_hr
  2   ADMIN USER pdb_hr identified by india123
  3   FILE_NAME_CONVERT=('/data/oracle/oradata/CDBTES/pdbseed/','/data/oracle/oradata/CDBTES/pdb_hr/');

Pluggable database created.

SQL>

SQL> COLUMN pdb_name FORMAT A20
SQL> SELECT pdb_name, status
  2  FROM   dba_pdbs
  3  ORDER BY pdb_name;

PDB_NAME             STATUS
-------------------- ---------
PDB$SEED             NORMAL
PDBTEST1             NORMAL
PDBTEST2             NORMAL
PDBTEST3             NORMAL
PDB_HR               NEW

SQL> SELECT name, open_mode
  2  FROM   v$pdbs
  3   ORDER BY name;


NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDBTEST1                       READ WRITE
PDBTEST2                       READ WRITE
PDBTEST3                       READ WRITE
PDB_HR                         MOUNTED



SQL> ALTER PLUGGABLE DATABASE PDB_HR OPEN READ WRITE;

Pluggable database altered.

SQL>


SQL> SELECT name, open_mode
  2  FROM   v$pdbs
  3  ORDER BY name;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDBTEST1                       READ WRITE
PDBTEST2                       READ WRITE
PDBTEST3                       READ WRITE
PDB_HR                         READ WRITE

Unplug a Pluggable Database (PDB) Manually

SQL> ALTER PLUGGABLE DATABASE PDB_HR CLOSE;
Pluggable database altered.

SQL> ALTER PLUGGABLE DATABASE PDB_HR UNPLUG INTO '/data/oracle/oradata/CDBTES/pdb_hr/pdb-hr.xml';
Pluggable database altered.

SQL> SELECT name, open_mode
  2  FROM   v$pdbs
  3  ORDER BY name;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDBTEST1                       READ WRITE
PDBTEST2                       READ WRITE
PDBTEST3                       READ WRITE
PDB_HR                         MOUNTED

SQL> DROP PLUGGABLE DATABASE PDB_HR  INCLUDING DATAFILES;

Pluggable database dropped.

SQL> SELECT name, open_mode
  2  FROM   v$pdbs
  3  ORDER BY name;
NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDBTEST1                       READ WRITE
PDBTEST2                       READ WRITE
PDBTEST3                       READ WRITE