How to export the dumpfile backup in Pluggable Database(PDB) using expdp in 19C
Posted by Mir Sayeed Hassan on September 17th, 2025
How to export the dumpfile backup in Pluggable Database(PDB) using expdp in 19C
Note: In Multitenant database., You will have the container database along with one or more PDB database.
Check the database status
SYS> select name, database_role, version from V$database, v$instance; NAME DATABASE_ROLE VERSION ------------------------------------- ORA19CDB PRIMARY 19.0.0.0.0
Check the PDB Database associated init.
SYS> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ---------------------------------- 2 PDB$SEED READ ONLY NO 4 PDB_TEST1 READ WRITE NO
Create a directory at OS & PDB Level
OS Level
[oracle@ora19cdb ~]$ mkdir -p /u02/backup/dump_bkp
PDB Level
SYS> create or replace directory dump_bkp as '/u02/backup/dump_bkp/'; Directory created.
SYS> grant read, write on directory dump_bkp to system; Grant succeeded.
Now run the EXPDP at schema level backup.
[oracle@ora19cdb dump_bkp]$ expdp system@PDB_TEST directory=dump_bkp dumpfile=hassan_17sep25.dmp logfile=hassan_17sep25.log schemas=hassan Export: Release 19.0.0.0.0 - Production on Wed Sep 17 05:44:04 2025 Version 19.25.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Password: Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/********@PDB_TEST directory=dump_bkp dumpfile=hassan_17sep25.dmp logfile=hassan_17sep25.log schemas=hassan Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/STATISTICS/MARKER Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/TABLE/TABLE . . exported "HASSAN"."TEST1" 9.662 MB 73281 rows . . exported "HASSAN"."TEST2" 20.58 KB 39 rows Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is: /u02/backup/dump_bkp/hassan_17sep25.dmp Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Wed Sep 17 05:45:02 2025 elapsed 0 00:00:51