[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/TA