我用exp user/pwd@name tables=(aaa) file=a.dmp query=id>0想导出aaa表中id>0的记录,但通不过,谢谢
解决方案 »
- 请问一下ORACLE的稳定性和MYSQL相比如何?
- oracle中对树形结构的查询,我想除了得到一列显示起始节点到当前节点的完整路径path外,还要有一列class2,如何实现?
- 删除ORACLE里的表
- 如何写一个这样的存储过程
- 求SQL语句
- 急:使用OLAP函数时报错!
- 谁来谈谈oracle比sql server优势的地方?
- 为什么有些系统表查询语句单句执行可以找到数据,而放到存储过程中执行却找不到数据??急
- 新手问:怎么修改约束条件?
- ORACLE能不能象MS SQL Server2000一样? 直接生成XML?
- 有关查询的问题
- 我想在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\"