DBA Hub

📋Steps in this guide1/2

How To Run Expdp In Pluggable Database(PDB)

In the multitenant database, For getting an export dump from the pluggable database, It is a bit different process.

oracle configurationintermediate
by OracleDba
14 views
1

Overview

In the multitenant database, For getting an export dump from the pluggable database, It is a bit different process. PLUGGABLE DATABASE(PDB) – PDBPRIM SCHEMA_NAME – TESTUSER ( this schema/user is present in PDB PDBPRIM) - Make sure PDB service is registered in the listener. 2. Add the entry in tnsnames.ora file for the pdb PDBPRIM. 3. Now create a directory for datapump under the PDB.(PDBPRIM)

Code/Command (click line numbers to comment):

1
$ lsnrctl status
2

Section 2

Code/Command (click line numbers to comment):

1
2
3
4
5
SQL> show pdbs
SQL> alter session set container=PDBPRIM;
SQL> create directory PDB_EXPDIR as '/data/backup';

$ expdp TESTUSER/TESTUSER@PDBPRIM dumpfile=TESTUSER.dmp logfile=TESTUSER.log directory=PDB_EXPDIR SCHEMAS=TESTUSER schemas=TESTUSER

Comments (0)

Please to add comments

No comments yet. Be the first to comment!