Oracle 11g expdp中query参数的使用

muri

[oracle@rhel6 ~]$ expdp system/123456 directory=dump dumpfile=query.dmp tables=zx.abc,zx.abce query=zx.abc:\"where id \< 4\",zx.abce:\"where id \< 4\"　　
Export: Release 11.2.0.4.0 - Production on Fri Dec 9 16:13:41 2016
　　
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
　　
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
　　
With the Partitioning, OLAP, Data Mining and Real Application Testing options
　　
FLASHBACK automatically enabled to preserve database integrity.
　　
Starting "SYSTEM"."SYS_EXPORT_TABLE_01":  system/******** directory=dump dumpfile=query.dmp tables=zx.abc,zx.abce query=zx.abc:"where id < 4",zx.abce:"where id < 4"
　　
Estimate in progress using BLOCKS method...
　　
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
　　
Total estimation using BLOCKS method: 384 KB
　　
Processing object type TABLE_EXPORT/TABLE/TABLE
　　
. . exported "ZX"."ABC"                                  5.898 KB       2 rows
　　
. . exported "ZX"."ABCE"                                 5.898 KB       2 rows
　　
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
　　
******************************************************************************
　　
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
　　
  /home/oracle/query.dmp
　　
Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at Fri Dec 9 16:14:04 2016 elapsed 0 00:00:19