expdp带条件导出单个表的数据

[oracle@testdb dmp]$ expdp \"testuser/testuser\" DIRECTORY=dpump_dir dumpfile=kevin.dmp tables=test_table query=\"where cust_no like \'066%\'\"         -------注意这里的转义符

Export: Release 10.2.0.1.0 - 64bit Production on Monday, 27 February, 2012 17:23:00

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Starting "CRMTEST"."SYS_EXPORT_TABLE_02":  "crmtest/********" DIRECTORY=dpump_dir dumpfile=kevin.dmp tables=test_table query="where cust_no like '066%'"
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 496 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "CRMTEST"."TEST_TABLE"                   4.674 MB   46171 rows
Master table "CRMTEST"."SYS_EXPORT_TABLE_02" successfully loaded/unloaded
******************************************************************************
Dump file set for CRMTEST.SYS_EXPORT_TABLE_02 is:
  /home/oracle/dmp/kevin.dmp
Job "CRMTEST"."SYS_EXPORT_TABLE_02" successfully completed at 17:25:28


另外发现一个关于expdp/impdp方面很全，而且有例子的博文：
http://sgadba.blog.163.com/blog/static/1370466602011112113862/