[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/
阅读(13431) | 评论(0) | 转发(0) |