Close Pluggable Database Dialog

The Close Pluggable Database dialog closes a pluggable database, which makes it inaccessible to normal users. This is sometimes required in order to perform certain administrative tasks.

Note:

Some pluggable database features in ODT, such as Clone Pluggable Database Dialog and Unplug Pluggable Database Dialog, automatically close the pluggable database or make it read-only, as part of their operation and so explicitly closing the pluggable database may not be required for those operations.

Note:

This is a feature of Oracle Database 12.1 or later.

Starting the Close Pluggable Database Dialog

To open the Close 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 close, right-click on it and choose Close.

The Close Pluggable Database Dialog appears as follows:

Description of the illustration close.gif

Using the Close Pluggable Database Dialog

The Close Pluggable Database Dialog has the following controls:

Control	Description
Database name	Displays the name of the pluggable database to be closed. This field cannot be modified.
Close mode	Specifies how the database is closed. If you select IMMEDIATE, all existing connections to the database are disconnected from the database and it closes immediately. If you select NORMAL, the database waits until all existing connections have closed before the database closes.
Preview SQL	View the SQL that will be executed with the OK button is pressed.
OK	Closes the pluggable database and this dialog.
Cancel	Closes this dialog without making any changes to the database.
Help	Opens this help page.