Pages

Search This Blog ...

Showing posts with label Data Pump. Show all posts
Showing posts with label Data Pump. Show all posts

Monday, April 11, 2016

What is Data Pump in Oracle 11g

In This tutorial i'll be show you how to manage data pump and as well as how many way to many it in oracle 11g R2

  This is server-based facility to manage high speed data and mata-data in oracle database.
  This datapump infrastructure is callable via DBMS_DATAPUMP in PL/SQL package.
  Oracle 11g database provide two tools as below,
  •  Through command line.
    • EXPDP
    • IMPDP
  •  Through web based called grid infrastructure.
  The oracle data pump have many benefits and some new features as below,
  1. Data selection and Fine-grained.
  2. Parallel execution.
  3. Explicit specification of database version.
  4. Network mode in distributed environment.
  5. Estimation of export job space consumption.
  6. Remapping capabilities.
  7. Compression of data during a data pump export.
  8. Data and Metadata compression.
  9. Ability to export XML type data as CLOB.
  10. Legacy mode to support old import and export files.