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
   1. Create a PDB by plugging an unplugged PDB into a CDB. I demonstrated this in Clone PDB from Unplugged PDB.
3. 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: