ORACLE11g中用EXPDP/IMPDP只导出/导入或者跳过指定job的方法

1、导出指定JOB对象

expdp userName/password directory=J_DATA dumpfile=fileName.DMP logfile=logfileName.LOG
include=procobj:\"in('JOB_A','JOB_B')\";

--只导出JOB_A和JOB_B两个job，注意：job名需要大写

2、导入指定JOB对象

impdp userName/password directory=J_DATA dumpfile=fileName.DMP include=procobj:\"in('JOB_A','JOB_B')\";

--只导入JOB_A和JOB_B两个job,注意：job名需要大写

3、导出数据时跳过特定JOB对象

expdp userName/password directory=J_DATA dumpfile=fileName.DMP logfile=logfileName.LOG
exclude=procobj:\"in('JOB_A','JOB_B')\";

--导出数据时不导JOB_A和JOB_B这两个job

4、导入数据时跳过特定JOB对象

impdp userName/password directory=J_ATA dumpfile=fileName.DMP exclude=procobj:\"in('JOB_A','JOB_B')\";

--导入数据时不导入JOB_A和JOB_B这两个job