We can create a pluggable database using dblink from a remote location.

Step 1: Check container database

Step 2: Connect to a pluggable database you want to clone :

Step 3: Create a user with which you want to clone pdb, you can use existing user too. The user should have created pluggable database privilege.

Step 4: Grant permission if not already done

Step 5: Close pluggable database

Step 6: Open pluggable database in the read-only state

Step 7: Connect to destination container database where you want to clone pdb, check details :

Step 8: Create tns entry for source pdb

Step 9: Create a database link using tns entry of pdb :

Step 10: Check your database link is working properly :

Step 11: Finally, use CREATE PLUGGABLE DATABASE FROM dblink statement to create the pluggable database

Step 12: Check pluggable database is created

Step 13: Open pluggable database

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us an Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.