Wednesday, August 5, 2020
    Home Oracle DBA Tips Compression in Datapump of Oracle 11g

    Compression in Datapump of Oracle 11g

    Compression feature of Oracle 11g Datapump

    The ability to constrict the meta-data associated with a Information Push job was first provided in Oracle Data source 10g Launch 2. In Oracle Data source 11g, this pressure capability has been extended so that desk data can be compacted on trade.

    Data Pump compression is an in-sequence process, so the decreased dump file size denotes an important savings in disk space. Dissimilar operating system or file system compression methods, Data Pump compression is entirely in order on the import side as well, so there is no require to uncompress a dump file before importing it. The compressed dump file sets are robotically decompressed throughout import devoid of any extra steps by the Database Administrator.

    - Advertisement -

    Full Information Push performance is available using a compacted data file. Any control that is used on a regular data file will also work on a compacted data file. Users have the following options to determine which parts of a dispose of information file set should be compressed:

    ALL enables pressure for the whole trade function.

    DATA-ONLY outcomes in all data being published to the dispose of information file in compacted structure.

    METADATA-ONLY outcomes in all meta-data being published to the dispose of information file in compacted structure. This is the standard.

    NONE immobilizes compression for the whole export process.

    The decrease in dump file size will differ based on data types and other things. Note that when importing using Data Pump, the CREATE TABLE statements will have compression clauses that match the explanation in the export file. If a compression clause is missing, then the table comes into the COMPRESSION characteristics of the tablespace where the table is stored.

    In Oracle Database 11g, Oracle provides the mechanism to compress both data and metadata during the extract operation. The available options for the COMPRESSION parameter are as follows:

    compression={all | data_only | metadata_only | none}

    Following is an example:

    $expdp full=yes userid=”‘/ as sysdba'”  dumpfile=dbadir:full.compress.dmp compression=all

    - Advertisment -

    Most Popular

    What was new in Oracle 12c

    Blog post explains in detail Oracle 12c new features for Developers including in-memory and Advanced Index Compression.

    The Life of DBAs is Changing

    Article explains how The Life of DBAs is Changing in Self-Managing Oracle Database. An detail introduction of Oracle Autonomous Database Cloud

    MySQL as PHP database

    The article illustrates the relationship between data and semantics of data stored in a database with reference to the semantic WEB

    Supply Chain Management in ERP

    The article provides detail of what is supply chain management system and what is the importance.

    Recent Comments