exp的QUERY选项怎使用? 我用exp user/pwd@name tables=(aaa) file=a.dmp query=id>0想导出aaa表中id>0的记录,但通不过,谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 exp user/pwd@name tables=aaa file=a.dmp query='id>0' exp user/pwd@name tables=(aaa) file=a.dmp query=(SELECT * FROM AAA WHERE id > 0) Sorry,更正:exp user/pwd@name tables=(aaa) file=a.dmp query=\"where id>0\" exp c/pd@CRM tables=(a) file=\var\a.bak query=\"where id=2\"我的可以通过的,试试 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 2005Copyright (c) 1982, 2004, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsExport done in ZHS16GBK character set and AL16UTF16 NCHAR character setAbout to export specified tables via Conventional Path .... . exporting table EMP 12 rows exportedEXP-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 2005Copyright (c) 1982, 2004, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsExport done in ZHS16GBK character set and AL16UTF16 NCHAR character setAbout to export specified tables via Conventional Path .... . exporting table EMP 0 rows exportedEXP-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 2005Copyright (c) 1982, 2004, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsExport done in ZHS16GBK character set and AL16UTF16 NCHAR character setAbout to export specified tables via Conventional Path .... . exporting table EMP 14 rows exportedEXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.Export terminated successfully with warnings.C:\> 就用 scott.emp 为例吧exp scott/tiger TABLES=emp QUERY=\"WHERE job=\'SALESMAN\' and sal\<1600\" 求助,怎么控制SQL Plus查询出来的结果显示!我想要所有的列在一行显示,值对应相应的列名!! 求救了!!!一个让人头疼的查询检索问题 请问PL/SQL中如何实现动态SQL查询 急急急。。请帮忙 征求oracle安装、管理、维护的要点 这SQL脚本咱写啊 ??求大侠帮忙,急急急 关于视图 !!!数据库启动不能!!! 系统是如何找到tnsnames.ora的? 请教关于在SQL中语句中 加了rownum的奇怪问题,谢谢 有关查询的问题 我想在oracle的存取过程中写一个取硬盘序列号的语句,这些语句要什么写?
exp user/pwd@name tables=(aaa) file=a.dmp query=\"where id>0\"
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 2005Copyright (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 setAbout 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 2005Copyright (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 setAbout 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 2005Copyright (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 setAbout 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:\>
exp scott/tiger TABLES=emp QUERY=\"WHERE job=\'SALESMAN\' and sal\<1600\"