Installation of new PDB

Type	Note
Create a PDB by using the seed	Use the create_pdb_from_seed clause to create a PDB by using the seed in the multitenant container database (CDB) as a template. The files associated with the seed are copied to a new location and the copied files are then associated with the new PDB.
Create a PDB by cloning an existing PDB or non-CDB (local or remote databases via DBLink)	Use the create_pdb_clone clause to create a PDB by copying an existing PDB or non-CDB and then plugging the copy into the CDB. The files associated with the existing PDB or non-CDB are copied to a new location and the copied files are associated with the new PDB.
Create a PDB by plugging an unplugged PDB into a CDB/td>	Use the create_pdb_from_xml clause to plug an unplugged PDB or a non-CDB into a CDB, using an XML metadata file.

Create a PDB by using the seed as a template

CREATE PLUGGABLE DATABASE PDB
ADMIN USER Admin IDENTIFIED BY oracle
FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/pdbseed/','/u01/app/oracle/oradata/PDB/') STORAGE (MAXSIZE 2G)
PATH_PREFIX = '/u01/app/oracle/oradata/PDB/';

SQL> !mkdir /u01/app/oracle/oradata/cdb/pdb1

SQL> create pluggable database pdb1 admin user pdb1_admin identified by oracle roles=(CONNECT)
create_file_dest='/u01/app/oracle/oradata/cdb/pdb1';

Pluggable database created.

SQL> select con_id, name, open_mode from v$pdbs;

	CON_ID NAME                           OPEN_MODE
---------- ------------------------------ ----------
		 2 PDB$SEED                       READ ONLY
		 3 PDB                            READ WRITE
		 4 PDB1                           MOUNTED

SQL> alter pluggable database pdb1 open;

Pluggable database altered.

SQL> select con_id, name, open_mode from v$pdbs;

	CON_ID NAME                           OPEN_MODE
---------- ------------------------------ ----------
		 2 PDB$SEED                       READ ONLY
		 3 PDB                            READ WRITE
		 4 PDB1                           READ WRITE

SQL> CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_adm IDENTIFIED BY oracle
  ROLES=(DBA)
  DEFAULT TABLESPACE test
	DATAFILE '/u01/app/oracle/oradata/cdb/pdb1/test01.dbf' SIZE 5M AUTOEXTEND ON
  file_name_convert=('/u01/app/oracle/oradata/cdb/pdbseed/','/u01/app/oracle/oradata/cdb/pdb1/');  

Pluggable database created.

SQL> col pdb_name for a10
SQL> select pdb_name, status from dba_pdbs;

PDB_NAME   STATUS
---------- ---------
PDB        NORMAL
PDB$SEED   NORMAL
PDB1       NEW

SQL> select con_id, name, open_mode from v$pdbs;

	CON_ID NAME                           OPEN_MODE
---------- ------------------------------ ----------
		 2 PDB$SEED                       READ ONLY
		 3 PDB                            READ ONLY
		 4 PDB1                           MOUNTED

SQL> alter pluggable database pdb1 open;

Pluggable database altered.

SQL> select pdb_name, status from dba_pdbs;

PDB_NAME   STATUS
---------- ---------
PDB        NORMAL
PDB$SEED   NORMAL
PDB1       NORMAL

SQL>  select con_id, name, open_mode from v$pdbs;

	CON_ID NAME                           OPEN_MODE
---------- ------------------------------ ----------
		 2 PDB$SEED                       READ ONLY
		 3 PDB                            READ ONLY
		 4 PDB1                           READ WRITE

SQL> alter session set container=pdb1;

Session altered.

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/cdb/pdb1/system01.dbf
/u01/app/oracle/oradata/cdb/pdb1/sysaux01.dbf
/u01/app/oracle/oradata/cdb/pdb1/test01.dbf

Cloning a Local PDB With the FILE_NAME_CONVERT:

	CREATE PLUGGABLE DATABASE pdb1 FROM pdb
	  FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/cdb/pdb/', '/u01/app/oracle/oradata/cdb/pdb1/')
	  NOLOGGING;