DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Saturday, August 30, 2014

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

1 comment:

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.