Introduction of Multitenant Architecture

A logical backup taken from NON-CDB database can be easily imported into a pluggable database without any overhead.

Let us see the example :

Step 1: Check the database status

Step 2 : Create the directory

Step 3 : Backup using expdp

Step 4 : Connect to CDB database

Step 5 : Create plugagble database if not already created :

Step 6 : Open pluggable database

Step 7 : Connect to pluggable database

Step 8 : Create directory where we can keep exported dmp file.

Step 9 : Create TNS entry for pdb in tnsnames.ora file

Step 10 : Check available tablespaces in pdb.

Step 11 : Add users tablespace asI had it in non-cdb database.

Step 12 : Transfer backup into respective directory and run impdp script

Stay tuned for More articles on Oracle Multitenant

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

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

Telegram Channel:

Skant Gupta’s LinkedIn:

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.