Question: I see that there is a new
compression_algorithm 12c parameters for Data
Pump.
Answer: Oracle offers several levels of
compression in Data Pump:
-
compression_algorithm=basic: This
level is not too CPU intensive and offers good
compression
-
compression_algorithm=high: This
is the most CPU intensive option, but the one that many
result in the smallest export dmp file.
-
compression_algorithm=medium: This
is similar to "basic" compression.
-
compression_algorithm=low: This
is for bases where the server is CPU bound and it will
give the largest of the compressed files.
Here is an example invocation of expdp using
compression_algorithm
/u01.app.oracle> expdp dumpfile=mytabs.dmp
tables=emp,dept compression_algorithm=high
