【oracle】exp中query 的使用

环境：

[oracle@gclab2 ~]$ uname -a
Linux gclab2.oracle.com 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:27:17 EDT 
2006 i686 i686 i386 GNU/Linux
 

执行：

[oracle@gclab2 ~]$  exp system/dang file=test.dmp log=test.log rows=y 
indexes=y grants=n tables=(yafeishi.test) 
query= \"where rownum \<100\" buffer=102400000

Export: Release 10.2.0.1.0 - Production on Wed Nov 16 23:10:24 2011

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
Note: grants on tables/views/sequences/roles will not be exported

About to export specified tables via Conventional Path ...
Current user changed to YAFEISHI
. . exporting table                           TEST 99 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
 

成功导出。

 本文用菊子曰发布