Create a CDB and PDB

Click on the link below for a tutorial on Oracle Multitenant Architecture - Creating a CDB and PDB. This link points to  a YouTube video.

Watch a YouTube video on Oracle 18c Multitenant Architecture - Create a CDB and PDB

Examples

CREATE PLUGGABLE DATABASE pdb1
ADMIN USER pdb1adm IDENTIFIED BY password
ROLES=(PDB_DBA)
STORAGE (MAXSIZE 2G)
DEFAULT TABLESPACE tbs_pdb1
DATAFILE 'C:\app\archana\product\18.0.0\oradata\XE\pdb1\datafile\pdb01.dbf' SIZE 250M AUTOEXTEND ON
PATH_PREFIX = 'C:\app\archana\product\18.0.0\oradata\XE\pdb1\'
CREATE_FILE_DEST='C:\app\archana\product\18.0.0\oradata\XE\pdb1\';

--drop pluggable database pdb1 including datafiles;

--alter pluggable database pdb1 close immediate;


/* Viewing information about each PDB */

COLUMN PDB_NAME FORMAT A15
SELECT PDB_ID, PDB_NAME, STATUS FROM DBA_PDBS ORDER BY PDB_ID;

/* Viewing the Name and Open Mode of Each PDB */

COLUMN NAME FORMAT A15
COLUMN RESTRICTED FORMAT A10
COLUMN OPEN_TIME FORMAT A30
SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDBS;


/* Showing the Users in Multiple PDBs */


COLUMN PDB_NAME FORMAT A15
COLUMN USERNAME FORMAT A30
SELECT p.PDB_ID, p.PDB_NAME, u.USERNAME
FROM DBA_PDBS p, CDB_USERS u
WHERE p.PDB_ID > 2 AND
p.PDB_ID = u.CON_ID
ORDER BY p.PDB_ID;


/* Showing the Data Files for Each PDB in a CDB */


COLUMN PDB_ID FORMAT 999
COLUMN PDB_NAME FORMAT A8
COLUMN FILE_ID FORMAT 9999
COLUMN TABLESPACE_NAME FORMAT A10
COLUMN FILE_NAME FORMAT A45
SELECT p.PDB_ID, p.PDB_NAME, d.FILE_ID, d.TABLESPACE_NAME, d.FILE_NAME
FROM DBA_PDBS p, CDB_DATA_FILES d
WHERE p.CON_ID = d.CON_ID
ORDER BY p.PDB_ID;




/* Showing the Temp Files in a CDB */

COLUMN CON_ID FORMAT 999
COLUMN FILE_ID FORMAT 9999
COLUMN TABLESPACE_NAME FORMAT A15
COLUMN FILE_NAME FORMAT A45
SELECT CON_ID, FILE_ID, TABLESPACE_NAME, FILE_NAME
FROM CDB_TEMP_FILES
ORDER BY CON_ID;