Datapump 11g COMPRESSION Parameter

Prior to
11g only METADATA_ONLY and NONE could be specified. With now COMPRESSION=ALL,
dumpfile
size can be greatly reduced so no need to use any
compression
utility
to compress the
dumpfile further.

METDATA_ONLY – Only the metadata is
compressed
DATA_ONLY –         Only the data is compressed; the metadata is left
alone.
ALL –                          Both the metadata and data are compressed.
NONE
–                      This is
the default; no
compression is
performed. 

Without compression parameter

expdp system/oracle schemas=scott
directory=TEST_DIR
dumpfile=scott.dmp
logfile=scott.log


Using compression parameter

expdp system/oracle schemas=scott
directory=TEST_DIR 
dumpfile=scott1.dmp
logfile=scott1.log compression=all
  • August 30, 2014 | 34 views