CPISOLUTION


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CPISOLUTION

22 23 Kensington Garden Square            

info@cpisolution.com

Architecture of Data Pump

•  Architecture of Oracle Data Pump

Creating the directory in the server

The dump files are stored in server rather than on client machines which makes it necessary to define a directory in server for storing dump files .It Is created using the following command.

create or replace directory test as 'c:\cpisolution';
grant read,write on directory cpisolution to scott;

You need to have create privilege directory to do this.

Oracle data pump consists of

Dbms_DATAPUMP
Using dbms_datapump you can call export tor import
Without using expdp or impdp .
Used for laoding or unlodading data.

Dbms_metadata This is used for defining Meta data

( Meta data means data about data)

Role of Master table .

Master process uses a special table called the master table to log the location of the various database objects in the export dump file. The master process maintains the job state and restart information in the master table.Oracle createsAs in case of data pump export import job finishes successfully. Oracle will delete the master table.

Access Paths it uses are Direct Path or Oracle_Datapump

Processes Involved Data pump chooses what is the fastest method appropriate for each tables. Data pump cannot use direct path loading if

•  A global index on multi partion tables exists during a single partion load

•  A domain index exsits for Lob column

•  A Table is in cluster

•  A table has fine grained aceess in insert mode.

•  A table has active trigger

•  A Table contains BFILE columns or columns of opaque type.

•  Oracle uses Oracle_datapump which is a external table access driver to read and write files.

•  This allows for high speed loading and unloading of database tables.