ANKUSH THAVALI03 Sep, 20230 Comments51 Secs ReadHow 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) – PDBPRIMSCHEMA_NAME – TESTUSER ( this schema/user is present in PDB PDBPRIM) 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 ! Oracle DBAShare: How To Generate AWR Report In RACORA-01624: Log 1 Needed For Crash Recovery Of Instance