Clone Pluggable Database Dialog
The Clone Pluggable Database Dialog allows you to make a clone of an existing pluggable database. The cloned pluggable database is added to the multitenant container database. New Oracle Database files (DBF files) are added to the database server filesystem. After the clone operation is complete, 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 Clone Pluggable Database Dialog
To open the Clone 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 clone, right-click on it, and choose Clone. A confirmation dialog appears, informing you that the pluggable database will be set to Read Only and that all existing connections to it will be lost.
Note:
The seed pluggable database cannot be cloned using this dialog. Instead, click on the Pluggable Databases Node and choose New Pluggable Database.
The Clone Pluggable Database Dialog appears as follows:
Using the Clone Pluggable Database Dialog
The Clone Pluggable Database Dialog has the following controls:
| Control | Description |
|---|---|
|
Target database name |
Enter name of the new pluggable database to be created. |
|
Source database name |
Displays the name of the pluggable database to be cloned. This field cannot be changed. |
|
Source Admin Name |
Enter the user name of the Administrator account for the pluggable database that is to be cloned. |
|
Source Admin password |
Enter the password for the Administrator account for the pluggable database that is to be cloned. |
|
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 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 when you press the OK button. |
|
OK |
Clones the pluggable database, opens the clone database, returns the source database to its original state, 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 |
|
Cancel |
Returns the source database to its original state and then closes this dialog without making any other changes to the database. |
|
Help |
Opens this help page. |