How to Export Full Pluggable Database using expdp: Running Your First Export

<<Back to Oracle DATAPUMP Main Page

Exporting Full Pluggable Database Using Parfile

$ expdp system@PDB01 parfile=exp_full_pdb01.par
Export: Release 12.2.0.1.0 - Production on Tue Oct 9 11:34:14 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
Password:
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Starting "SYSTEM"."SYS_EXPORT_FULL_01":  system/********@PDB01 parfile=exp_full_pdb01.par
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
...............................................................................................................................................
...............................................................................................................................................
. . exported "TEST"."PEOPLE"                             6.796 KB       1 rows
Master table "SYSTEM"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is:
  /u01/dbatst2/stage/dump/EXP_PDB01_FULL01.dmp
Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at Tue Oct 9 11:37:26 2018 elapsed 0 00:03:00


expdp     <= datapump export utility
system   <= User performing database export
PDB01   <= Database being exported. Name must be defined in TNSNAMES.ORA
parfile     <= Name of the parameter file where the export parameters are defined

Here is my parfile with very besic parameters I used to Export the Database  
$ cat exp_full_pdb01.par
directory=dump
dumpfile=EXP_PDB01_FULL%U.dmp
logfile=EXP_PDB01_FULL.log
full=y
flashback_scn=3104076

A Brief Description of Parameters used in parfile
directory:
A virtual directory name in database pointing to a physical OS directory in my case /u01/dbatst2/stage/dump used to hold the dumpfile and logfile generated by expdp
If the directory is not created, then login to your pluggable database and create the directory as follows.
NOTE: Ensure that the directory is created in PDB and not in CDB
SQL> alter session set container=PDB01;
Session altered.
SQL> create directory dump as '/u01/dbatst2/stage/dump';
Directory created.
Find the Directory in Database
set line 200
col OWNER for a10
col DIRECTORY_NAME for a30
col DIRECTORY_PATH for a50
select * from dba_directories where DIRECTORY_NAME like '%DUMP%';
OWNER      DIRECTORY_NAME                 DIRECTORY_PATH                                     ORIGIN_CON_ID
---------- ------------------------------ -------------------------------------------------- -------------
SYS        DUMP                           /u01/dbatst2/stage/dump                                        3

dumpfile:
Name of the dumpfile
logfile:
Name of the logfile
Full=y:
Exporting full database
flashback_scn:
Making export consistent at specific Database SCN
Note: To find the current database scn run below command as sys user 
select current_scn from v$database;