This tutorial describes three important activities to help you manage pluggable databases (PDB) using Oracle SQL Developer.
Time to Complete
Approximately 45 minutes
The tutorial covers the three following activities:
- Modifying the state of a pluggable databas
- Creating a pluggable database from an existing pluggable database
- Unplugging and plugging a pluggable database
Before starting this tutorial, you should have:
- Oracle SQL Developer 4.0 software, which is available on the Oracle Technology Network
- Oracle Database 12c software, which is available at Oracle Database Software Downloads
- Understand Oracle Database 12c concepts. Documentation is available online at Oracle® Database Concepts 12c Release 1 (12.1).
Setting up the Environment
Creating a Database Connection
Adding a Connection to the DBA Navigator
In SQL Developer, the DBA Navigator enables you to perform full administration of container databases and pluggable databases.
Modifying the State of a Pluggable Database
Before you can clone a pluggable database, it has to be Closed and Opened in Read Only mode.
Cloning a Pluggable Database
You can create additional pluggable databases by cloning an existing pluggable database. Perform the tasks below to create a clone of PDB1 named PDB3.
Unplugging and Plugging a Pluggable Database
Unplugging the Database
You can unplug a database from one container database and later plug it into the same (or another) container database.
Plugging in the Database
Note: The steps for plugging a PDB into a different container database are essentially the same as those for plugging it into the container database from which it was unplugged. Here, you will plug PDB3 back into the same container database--while recognizing that, in the real world, selecting a different container database would make more business sense.
This brief tutorial described three important activities to help you manage pluggable databases.
In this tutorial, you learned how to:
- Modify the state of a pluggable database
- Create a pluggable database from an existing pluggable database
- Unplug and plug a pluggable database
Additional information about Oracle and Oracle technologies is available at the following sites:
- To learn more about Oracle database technologies, visit www.oracle.com.
- To view Oracle Database documentation, see Oracle Database Documentation on the Oracle Technology Network.
- To look for more OBEs related to Oracle Database, visit the Oracle Learning Library.
- Lead Curriculum Developer: Pete DeHaan
- Other Contributors: Ashley Chen, Nancy Greenberg
To navigate this Oracle by Example tutorial, note the following:
- Hide Header Buttons:
- Click the title to hide the buttons in the header. To show the buttons again, click the title again.
- Topic List:
- Click a topic to navigate to that section.
- Expand All Topics:
- Click the button to show or hide the details for the sections. By default, all topics are collapsed.
- Hide All Images:
- Click the button to show or hide the screenshots. By default, all images are displayed.
- Click the button to print the content. The content that is currently displayed or hidden is printed.
To navigate to a particular section in this tutorial, select the topic from the list.