In this post, we will see how we can take an export from one pdb and import into another pdb.

Step 1: Connect to pdb from where you want to take export :

Step 2: Create a directory for data pump export :

Step 3: Create tns entry in tnsnames.ora for the pluggable database if not already done :

Step 4: Grant necessary privileges to the user with whom you want to take backup :

Step 5: Take export using expdp and give clause full=Y

Step 6: Connect to target pdb where you want to import dump.

Step 7: Create a directory for data pump import 

Step 8: Create a tns entry 

Step 9: Import using impdp 

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.