Oracle Data Pump 研究(一)

Oracle Data Pump is a newer, faster and more flexible alternative to the "exp" and "imp" utilities used in previous Oracle versions.

一、Getting Started

       Create a directory object it can access,The directory object is only a pointer to a physical directory, creating it does not actually create the physical directory on the file system.

      All data pump actions are performed by multiple jobs (server processes not DBMS_JOB jobs). 
      These jobs are controlled by a master control process which uses Advanced Queuing. At runtime an advanced queue table, named after the job name, is created and used by the master control process. The table is dropped on completion of the data pump job. The job and the advanced queue can be named using the  parameter. 
. Issuing "ctrl+c" on the client during a job stops the client output and presents a command prompt. Typing "status" at this prompt allows you to monitor the current job.

        Data pump performance can be improved by using the  parameter. This should be used in conjunction with the "%U" wildcard in the  parameter to allow multiple dumpfiles to be created or read.
        The  view can be used to monitor the current jobs

      The  and  parameters can be used to limit the export/import to specific objects. When the  parameter is used, only those objects specified by it will be included in the export. When the  parameter is used all objects except those specified by it will be included in the export.

 e.g.

To run this job without a parameter file, you need to escape the special characters. Incorrect escaping can result in errors such as: ksh: syntax error: '(' unexpected.
Command line examples (for Windows: type parameters on one single line) :

Windows:
D:\> expdp system/manager DIRECTORY=my_dir DUMPFILE=exp_tab.dmp LOGFILE=exp_tab.log
SCHEMAS=scott INCLUDE=TABLE:\"IN ('EMP', 'DEP')\"
Unix:
% expdp system/manager DIRECTORY=my_dir DUMPFILE=exp_tab.dmp LOGFILE=exp_tab.log \
SCHEMAS=scott INCLUDE=TABLE:\"IN \(\'EMP\', \'DEP\'\)\"

参考文献：
1.http://www.oracle-base.com/articles/10g/OracleDataPump10g.php

2.http://space.itpub.net/673608/viewspace-629496

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9252210/viewspace-666738/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9252210/viewspace-666738/