Unplug Pluggable Database Dialog

The Unplug Pluggable Database Dialog allows you to unplug a pluggable database. This closes the pluggable database, removes it from the multitenant container database and creates an XML metadata file. This metadata file and the corresponding Oracle Database files (DBF files) remain on the database server filesystem and can be plugged back into the same multitenant container database at a later time or plugged into other container databases that use the same character set as the pluggable database. In most cases, unplugging a pluggable database is preferred rather than permanently deleting it.

Note:

This is a feature of Oracle Database 12.1 or later.

Starting the Unplug Pluggable Database Dialog

To open the Unplug Pluggable Database Dialog, connect to Server Explorer with a user that has SYSDBA privileges. Expand the Pluggable Databases Node and view the list of Pluggable Database Nodes. When you have located the pluggable database that you wish to unplug, right-click on it and choose Unplug.

The Unplug Pluggable Database Dialog appears as follows:

Description of the illustration unplug.gif

Using the Unplug Pluggable Database Dialog

The Unplug Pluggable Database Dialog has the following controls:

Control	Description
Database name	Displays the name of the pluggable database to be unplugged. This field cannot be modified.
XML File Name	Displays name of the XML file that contains the metadata for the pluggable database.
XML File Location	Displays the path on the database server filesystem to the XML file that contains the metadata for the pluggable database.
Preview SQL	View the SQL to be executed with the OK button is pressed.
OK	Closes and unplugs the pluggable database and closes this dialog.
Cancel	Closes this dialog without making any changes to the database.
Help	Opens this help page.