New Pluggable Database Dialog

The New Pluggable Database Dialog allows you to create a new pluggable database, which is added to the multitenant container database. New Oracle Database files (DBF files) are added to the database server filesystem. Afterwards, if the option is chosen in the General Options Page, an administrator connection is automatically made to the new pluggable database in Server Explorer, and if the connection to the container database is using a TNS alias, a connection alias is created for it in the tnsnames.ora file.

Note:

This is a feature of Oracle Database 12.1 or later.

Starting the New Pluggable Database Dialog

To open the New Pluggable Database Dialog, connect to Server Explorer with a user that has SYSDBA privileges. Right-click the Pluggable Databases Node and choose New Pluggable Database.

The New Pluggable Database Dialog appears as follows:

Description of newpluggable.gif follows
Description of the illustration newpluggable.gif

Using the New Pluggable Database Dialog

The New Pluggable Database Dialog has the following controls:

Control Description

Database name

Enter the name of the new pluggable database to be created

Administrator name

Enter the user name of the Administrator account for the pluggable database to be created.

Administrator password

Enter the password for the Administrator account for the pluggable database to be created.

Grant DBA role and UNLIMITED TABLESPACE to administrator

Grants the DBA role and UNLIMITED TABLESPACE privilege to the administrator account.

Show Advanced

Enable this check box to display additional fields, allowing you to specify the data file names and locations for the new pluggable database.

Specify the names and locations of the datafiles of the new pluggable database

Lists new pluggable database datafile names and their locations on the database server filesystem. Both the Data File Name and Data File Location field can be modified as desired.

Preview SQL

View the SQL to be executed with the OK button is pressed.

OK

Creates and opens the pluggable database and then closes this dialog. If the option is chosen in the General Options Page, it also makes a connection to it in Server Explorer as the administrator account and adds an entry to the tnsnames.ora file (if the connection to the container database used a TNS alias).

Cancel

Closes this dialog without making any changes to the database.

Help

Opens this help page.