<<Back to Oracle DATAPUMP Main Page
CONTENT parameter of expdp let you select whether you want to export only data or only metadata or both
Default: ALL
Syntax and Description
CONTENT=[ALL | DATA_ONLY | METADATA_ONLY]
- DATA_ONLY exports only table row data; no database object definitions are exported.
- METADATA_ONLY exports only database object definitions; no table row data is exported.
Exporting metadata only
$ cat exp_full_pdb01.par
directory=dump
dumpfile=EXP_PDB01_FULL%U.dmp
logfile=EXP_PDB01_FULL.log
full=y
CONTENT=METADATA_ONLY
directory=dump
dumpfile=EXP_PDB01_FULL%U.dmp
logfile=EXP_PDB01_FULL.log
full=y
CONTENT=METADATA_ONLY
$ expdp system@PDB01 parfile=exp_full_pdb01.par
Exporting data only
directory=dump
dumpfile=EXP_PDB01_FULL%U.dmp
logfile=EXP_PDB01_FULL.log
full=y
CONTENT=DATA_ONLY
dumpfile=EXP_PDB01_FULL%U.dmp
logfile=EXP_PDB01_FULL.log
full=y
CONTENT=DATA_ONLY
$ expdp system@PDB01 parfile=exp_full_pdb01.par
Comments
Post a Comment