Create and manage pluggable databases

Overview

Create and manage pluggable databases.

Reference

• My 12c OCP Upgrade Exam Wiki
• Configuring and Creating CDBs and PDBs
• Create and configure a PDB
• Database 2 Day DBA
• 2 Installing Oracle Database and Creating a Database
• 2.3 Creating and Managing a Database with DBCA
• 2.3.6 Using DBCA to Manage PDBs
• 2.3.6.1 Managing PDBs in a CDB using DBCA
• Oracle ^® 12.1 Database Administrator's Guide
• 38 Creating and Removing PDBs with SQL*Plus
• 38.1 About Creating and Removing PDBs
• 38.1.1 Techniques for Creating a PDB

Procedure

Use DBCA to Create a PDB

The simplest procedure is to use DBCA as described in Managing PDBs in a CDB using DBCA . My investigation of this procedure can be found in “ Create PDB using DBCA (Simple) ”.

Manual Procedures for Creating a PDB

In 38.1.1 Techniques for Creating a PDB , the following ways to create a PDB are listed:

1. Create a PDB by using the seed
2. Create a PDB by cloning an existing PDB or non-CDB
3. Create a PDB by plugging an unplugged PDB into a CDB. I demonstrated this in Clone PDB from Unplugged PDB .
4. Create a PDB by using a non-CDB

These procedures are described in “ Create and configure a PDB ” as part of the 12 OCP Upgrade Exam. I also investigate SNAPSHOT COPY clones here.

Use OEM to Create a PDB

When I try to use OEM to provision a PDB, I get a warning that I need to licence “Database Lifecycle Management Pack” as shown in the following screenshot: