<<Back to Oracle DATAPUMP Main Page
Exporting Full Pluggable Database Using Parfile
$ expdp system@PDB01 parfile=exp_full_pdb01.parExport: 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;
Comments
Post a Comment