My blog is all about sharing and learning oracle.Please test before you apply anything on production.You may reach to me at vishwanathsh82@gmail.com

Wednesday, September 21, 2011

COMPRESSION and CONTENT parameter in Data pump.

COMPRESSION:

COMPRESSION parameter is used to compress our export dumpfile.This is different to prior OS-level utilities where we faced CPU utilization issue & also involved two steps (export the data & compress the dump file).in order to accomplish this task.

It specifies which data to compress before writing to the dump file set.

Options:

COMPRESSION={ALL | DATA_ONLY | METADATA_ONLY | NONE}

ALL enables compression for the entire export operation.

DATA_ONLY results in all data being written to the dump file in compressed format.

METADATA_ONLY results in all metadata being written to the dump file in compressed format. This is the default.

NONE disables compression for the entire export operation.

There is no difference during import using compressed dumpfile/uncompressed dumpfile.

TRANSLATE MY PAGE PLZ

Oracle database adminstrator

That's Me...

An oracle DBA and blogger having 6 + years of experience in Designing,Installation and Maintenance of oracle databases ranging from 9i,10g and 11g. Deployed and Tuned TB's databases successfully on various platforms such as Linux and Windows etc.