Visit Counter

Tuesday, December 3, 2013

Oracle 12c Database: Cloning PDB using SQL Developer



How to clone a PDB1 database using of SQL Developer

Modify the State to Read Only (If Open then Shutdown and Open in Read Only mode)


Use the Clone Pluggable Database Option

First you have to shutdown the PDB1 database.





See the status of PDB1.


 Start database read only mode.


 Right click on PDB1 database and select the Clone Pluggable database option.


 Change the Database Name: NEW_PDB & Select the File Name Conversion option.



Goto to SQL tab and change the Clone database files path.



Clone database created.




You can start the clone NEW_PDB database.





Create the new connection for "test" user which ready created in PDB1.





Verify the data in NEW_PDB database.

Now you start the PDB1 database for normal operation.

No comments:

Post a Comment