Oracle 11G EXPDP 按条件导出

EXPDP按条件导出，将下面SQL语句的查询结果导出

expdp tyyw/tyyw@cdlocal parfile='D:\Expdp_Cd.par'

--需导出的数据SQL

SELECT * FROM XT_AG_AJSLDY WHERE SLMC = '未报捕职务犯罪案件受理' OR SLMC = '捕后拟撤销或变更强制措施职务犯罪案件受理'
SELECT * FROM XT_AG_YSWSPZ WHERE JSLBMC = '未报捕职务犯罪案件' OR JSLBMC = '捕后拟撤销或变更强制措施职务犯罪案件'
SELECT * FROM XT_AK_MBCC WHERE AKMBMC = '未报捕职务犯罪' OR AKMBMC = '捕后拟撤销或变更强制措施职务犯罪'
SELECT * FROM XT_DM_AJLBBM WHERE AJLBMC = '未报捕职务犯罪案件' OR AJLBMC = '捕后拟撤销或变更强制措施职务犯罪案件'
SELECT * FROM XT_DM_FLDM WHERE LBBM IN (SELECT LBBM FROM XT_DM_FLDMLB WHERE LBMC = '未报捕审结处理结果' OR LBMC = '捕后拟撤销或变更强制措施审结处理结果')
SELECT * FROM XT_DM_FLDMLB WHERE LBMC = '未报捕审结处理结果' OR LBMC = '捕后拟撤销或变更强制措施审结处理结果'
SELECT * FROM XT_LC_CLCX WHERE CLCXBM LIKE '510100%'
SELECT * FROM XT_LC_JZXZMLDY WHERE LCMBBM LIKE '510100%'
SELECT * FROM XT_LC_MB WHERE LCMBBM LIKE '510100%'
SELECT * FROM XT_LC_MBAKZY WHERE LCMBBM LIKE '510100%'
SELECT * FROM XT_LC_MBDZZY WHERE LCMBBM LIKE '510100%'
SELECT * FROM XT_LC_MBJD WHERE LCMBBM LIKE '510100%'
SELECT * FROM XT_LC_MBJZZY WHERE LCMBBM LIKE '510100%'
SELECT * FROM XT_LC_MBWSZY WHERE LCMBBM LIKE '510100%'
SELECT * FROM XT_QX_GNDY WHERE GNBM LIKE '510100%'
SELECT * FROM XT_QX_GNFL WHERE FLBM LIKE '510100%'
SELECT * FROM XT_WS_BQSJY WHERE WSMBBH LIKE '510100%'
SELECT * FROM XT_WS_HSSJY WHERE SJYBM LIKE '510100%'
SELECT * FROM XT_WS_LBBM WHERE WSLBBM LIKE '510100%'
SELECT * FROM XT_WS_MB WHERE WSMBBH LIKE '510100%'
SELECT * FROM XT_YSJ_MXBM WHERE MXMC = '未报捕职务犯罪案件' OR MXMC = '捕后拟撤销或变更强制措施职务犯罪'
SELECT * FROM XT_YSJ_MXSTGX WHERE MXBM IN (SELECT MXBM FROM XT_YSJ_MXBM WHERE MXMC = '未报捕职务犯罪案件' OR MXMC = '捕后拟撤销或变更强制措施职务犯罪')
SELECT * FROM XT_YSJ_SJCDDY WHERE SJCDMBMC LIKE '%未报捕职务犯罪' OR SJCDMBMC LIKE '%捕后拟撤销或变更强制措施职务犯罪案件'
SELECT * FROM XT_YSJ_SJCDMX WHERE MBAJLBBM = '0223' OR MBAJLBBM = '0224'
SELECT * FROM XT_YSJ_SJFB WHERE FBDWBM = '510100'
SELECT * FROM XT_DM_BDFLDM WHERE DM LIKE '510100%'
SELECT * FROM XT_DM_BDFLDMLB WHERE LBBM LIKE '510100%'

--编辑02.par文件

COMPRESSION=ALL
DUMPFILE=TYYW_EXPDP_20141120.dmp  
DIRECTORY=DATA_PUMP_DIR   
LOGFILE=TYYW_EXPDP_20141120.log
CONTENT=DATA_ONLY
tables=
(
 TYYW.XT_AG_AJSLDY,
 TYYW.XT_AG_YSWSPZ,
 TYYW.XT_AK_MBCC,
 TYYW.XT_DM_AJLBBM,
 TYYW.XT_DM_FLDM,
 TYYW.XT_DM_FLDMLB,
 TYYW.XT_LC_CLCX,
 TYYW.XT_LC_JZXZMLDY,
 TYYW.XT_LC_MB,
 TYYW.XT_LC_MBAKZY,
 TYYW.XT_LC_MBDZZY,
 TYYW.XT_LC_MBJD,
 TYYW.XT_LC_MBJZZY,
 TYYW.XT_LC_MBWSZY,
 TYYW.XT_QX_GNDY,
 TYYW.XT_QX_GNFL,
 TYYW.XT_WS_BQSJY,
 TYYW.XT_WS_HSSJY,
 TYYW.XT_WS_LBBM,
 TYYW.XT_WS_MB,
 TYYW.XT_YSJ_MXBM,
 TYYW.XT_YSJ_MXSTGX,
 TYYW.XT_YSJ_SJCDDY,
 TYYW.XT_YSJ_SJCDMX,
 TYYW.XT_YSJ_SJFB,
 TYYW.XT_DM_BDFLDM,
 TYYW.XT_DM_BDFLDMLB
)
query=
(
 TYYW.XT_AG_AJSLDY:"WHERE SLMC = '未报捕职务犯罪案件受理' OR SLMC = '捕后拟撤销或变更强制措施职务犯罪案件受理'",
 TYYW.XT_AG_YSWSPZ:"WHERE JSLBMC = '未报捕职务犯罪案件' OR JSLBMC = '捕后拟撤销或变更强制措施职务犯罪案件'",
 TYYW.XT_AK_MBCC:"WHERE AKMBMC = '未报捕职务犯罪' OR AKMBMC = '捕后拟撤销或变更强制措施职务犯罪'",
 TYYW.XT_DM_AJLBBM:"WHERE AJLBMC = '未报捕职务犯罪案件' OR AJLBMC = '捕后拟撤销或变更强制措施职务犯罪案件'",
 TYYW.XT_DM_FLDM:"WHERE LBBM IN (SELECT LBBM FROM XT_DM_FLDMLB WHERE LBMC = '未报捕审结处理结果' OR LBMC = '捕后拟撤销或变更强制措施审结处理结果')",
 TYYW.XT_DM_FLDMLB:"WHERE LBMC = '未报捕审结处理结果' OR LBMC = '捕后拟撤销或变更强制措施审结处理结果'",
 TYYW.XT_LC_CLCX:"WHERE CLCXBM LIKE '510100%'",
 TYYW.XT_LC_JZXZMLDY:"WHERE LCMBBM LIKE '510100%'",
 TYYW.XT_LC_MB:"WHERE LCMBBM LIKE '510100%'",
 TYYW.XT_LC_MBAKZY:"WHERE LCMBBM LIKE '510100%'",
 TYYW.XT_LC_MBDZZY:"WHERE LCMBBM LIKE '510100%'",
 TYYW.XT_LC_MBJD:"WHERE LCMBBM LIKE '510100%'",
 TYYW.XT_LC_MBJZZY:"WHERE LCMBBM LIKE '510100%'",
 TYYW.XT_LC_MBWSZY:"WHERE LCMBBM LIKE '510100%'",
 TYYW.XT_QX_GNDY:"WHERE GNBM LIKE '510100%'",
 TYYW.XT_QX_GNFL:"WHERE FLBM LIKE '510100%'",
 TYYW.XT_WS_BQSJY:"WHERE WSMBBH LIKE '510100%'",
 TYYW.XT_WS_HSSJY:"WHERE SJYBM LIKE '510100%'",
 TYYW.XT_WS_LBBM:"WHERE WSLBBM LIKE '510100%'",
 TYYW.XT_WS_MB:"WHERE WSMBBH LIKE '510100%'",
 TYYW.XT_YSJ_MXBM:"WHERE MXMC = '未报捕职务犯罪案件' OR MXMC = '捕后拟撤销或变更强制措施职务犯罪'",
 TYYW.XT_YSJ_MXSTGX:"WHERE MXBM IN (SELECT MXBM FROM XT_YSJ_MXBM WHERE MXMC = '未报捕职务犯罪案件' OR MXMC = '捕后拟撤销或变更强制措施职务犯罪')",
 TYYW.XT_YSJ_SJCDDY:"WHERE SJCDMBMC LIKE '%未报捕职务犯罪' OR SJCDMBMC LIKE '%捕后拟撤销或变更强制措施职务犯罪案件'",
 TYYW.XT_YSJ_SJCDMX:"WHERE MBAJLBBM = '0223' OR MBAJLBBM = '0224'",
 TYYW.XT_YSJ_SJFB:"WHERE FBDWBM = '510100'",
 TYYW.XT_DM_BDFLDM:"WHERE DM LIKE '510100%'",
 TYYW.XT_DM_BDFLDMLB:"WHERE LBBM LIKE '510100%'"
)

--注意 :"冒号前无空格。表名不能重复使用，表不能有别名