Open Pluggable Database Dialog

The Open Pluggable Database dialog opens a pluggable database, which makes it accessible to normal users.

Note:

This is a feature of Oracle Database 12.1 or later.

Starting the Open Pluggable Database Dialog

To open the Open 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. Closed pluggable databases have a small red x in their icon. When you have located the pluggable database that you wish to Open, right-click on it and choose Open.

The Open Pluggable Database Dialog appears as follows:

Description of the illustration open.gif

Using the Open Pluggable Database Dialog

The Open 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.
Open mode	Specifies how the database opens. If you select READ WRITE, the database can be used normally for all operations. If you select READ ONLY, no operations that modify the database are allowed.
Restricted	Enable this check box to allow access to this pluggable database only to users that have been granted the RESTRICTED SESSION privilege.
Preview SQL	View the SQL to be executed when the OK button is pressed.
OK	Opens the pluggable database and closes this dialog.
Cancel	Closes this dialog without making any changes to the database.
Help	Opens this help page.