exp的QUERY选项怎使用？
我用exp user/pwd@name tables=(aaa) file=a.dmp query=id>0想导出aaa表中id>0的记录，但通不过，谢谢 问题点数：0、回复次数：11Top
1 楼nbnasom（阿飞）回复于 2004-12-03 13:52:33 得分 0
exp user/pwd@name tables=aaa file=a.dmp query='id>0'
Top
2 楼wangybyangxr（王永斌）回复于 2004-12-03 13:56:40 得分 0
exp user/pwd@name tables=(aaa) file=a.dmp query=(SELECT * FROM AAA WHERE id > 0)Top
3 楼wangybyangxr（王永斌）回复于 2004-12-03 14:14:52 得分 0
Sorry，更正：
exp user/pwd@name tables=(aaa) file=a.dmp query=\"where id>0\"
Top
4 楼dlab（老虎学艺）回复于 2004-12-04 17:21:29 得分 0
楼上正解Top
5 楼liuyi8903（不让疑问伴随）回复于 2004-12-04 23:47:30 得分 0
UP:)Top
6 楼smallcrocodile（大鳄鱼）回复于 2004-12-05 10:09:36 得分 0
看看，能不能学一招Top
7 楼killserver（killserver）回复于 2005-01-21 13:29:18 得分 0
不行，说是SQL没有正确结束Top
8 楼yown（yong）回复于 2005-01-21 16:22:48 得分 0
exp c/pd@CRM tables=(a) file=\var\a.bak query=\"where id=2\"
我的可以通过的，试试
Top
9 楼daydayupliq（敞开胸怀！）回复于 2005-01-21 17:51:40 得分 0
exp scott/liq tables=(EMP) FILE='d:\1.dmp' query="""where sal>1000"""
exp scott/liq tables=(EMP) FILE='d:\1.dmp' query=\"where sal>5000\"
都可以的~
C:\>exp scott/liq tables=(EMP) FILE='d:\1.dmp' query="""where sal>1000"""
Export: Release 10.1.0.3.0 - Production on 星期五 1月 21 17:51:15 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table EMP 12 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
C:\>exp scott/liq tables=(EMP) FILE='d:\1.dmp' query=\"where sal>5000\"
Export: Release 10.1.0.3.0 - Production on 星期五 1月 21 17:51:56 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table EMP 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
C:\>exp scott/liq tables=(EMP) FILE='d:\1.dmp' query=\"where sal>500\"
Export: Release 10.1.0.3.0 - Production on 星期五 1月 21 17:52:20 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table EMP 14 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
C:\>
Top
10 楼liuyi8903（不让疑问伴随）回复于 2005-01-29 13:59:28 得分 0
就用 scott.emp 为例吧
exp scott/tiger TABLES=emp QUERY=\"WHERE job=\'SALESMAN\' and sal\<1600\"Top
11 楼bisliu（还在潜水的鱼）回复于 2005-01-29 14:35:08 得分 0
学习了！Top
