Plug Pluggable Database Dialog
The Plug Pluggable Database Dialog allows you to plug in a pluggable database. A pluggable database is represented by an XML file plus some Oracle Database files (DBF files). These files must reside on the database server filesystem.
Note:
The container database must use the same character set as the pluggable database for the Plug operation to be successful.
Note:
This is a feature of Oracle Database 12.1 or later.
Starting the Plug Pluggable Database Dialog
To open the Plug Pluggable Database Dialog, connect to Server Explorer with a user that has SYSDBA privileges. Right-click on the Pluggable Databases Node and choose Plug.
The Plug Pluggable Database Dialog appears as follows:
Using the Plug Pluggable Database Dialog
The Plug Pluggable Database Dialog has the following controls:
| Control | Description |
|---|---|
|
Database name |
Select the name of the pluggable database to be plugged in. |
|
XML File Name |
Enter the name of the XML file that contains the metadata for the pluggable database. |
|
XML File Location |
Enter the path to the XML file that contains the metadata for the pluggable database on the database server filesystem. |
|
Show Advanced |
Check 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 existing pluggable database |
Lists 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 when the OK button is pressed. |
|
OK |
Plugs in and opens the pluggable database and closes this dialog. |
|
Cancel |
Closes this dialog without making any changes to the database. |
|
Help |
Opens this help page. |