How To Run Expdp In Pluggable Database(PDB)

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 03 Sep, 2023
  • 0 Comments
  • 51 Secs Read

How To Run Expdp In Pluggable Database(PDB)

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.

 

PLUGGABLE DATABASE(PDB) – PDBPRIM
SCHEMA_NAME – TESTUSER ( this schema/user is present in PDB PDBPRIM)

  1. Make sure PDB service is registered in the listener.
$ lsnrctl status

2. Add the entry in tnsnames.ora file for the pdb PDBPRIM.

3. Now create a directory for datapump under the PDB.(PDBPRIM)

 

SQL> show pdbs
SQL> alter session set container=PDBPRIM;
SQL> create directory PDB_EXPDIR as '/data/backup';
4. Now run the EXPDP:
$ expdp TESTUSER/TESTUSER@PDBPRIM dumpfile=TESTUSER.dmp logfile=TESTUSER.log directory=PDB_EXPDIR SCHEMAS=TESTUSER schemas=TESTUSER

Hope It Helps !