exp参数feedback_oracle exp query使用解决-LRM-00101: 未知的参数名

Oracle exp导出query使用：

Windows环境下：

C:\Documents and Settings\Administrator>

C:\Documents and Settings\Administrator>

C:\Documents and Settings\Administrator>exp

user/password@oracle tables=table1 rows=y indexes=y compress=y

buffer=65536 feedback=100000 file=D:\test1.dmp

log=D:\test1.log QUERY="WHERE name='zhangsan'"

LRM-00101: 未知的参数名 'phonenum'

EXP-00019: 处理参数失败, 请键入 'EXP HELP=Y' 获取帮助信息

EXP-00000: 导出终止失败

C:\Documents and Settings\Administrator>exp

user/password@oracle tables=table1 rows=y indexes=y compress=y

buffer=65536 feedback=100000 file=D:\test1.dmp

log=D:\test1.log QUERY='WHERE name="zhangsan"'

Export: Release 10.2.0.1.0 - Production on 星期五 12月 31 10:40:54

2010

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

reserved.

连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -

Production

With the Partitioning, OLAP and Data Mining options

已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集

即将导出指定的表通过常规路径...

. .

正在导出表 table1

导出了 1 行

EXP-00091: 正在导出有问题的统计信息。

EXP-00091: 正在导出有问题的统计信息。

EXP-00091: 正在导出有问题的统计信息。

EXP-00091: 正在导出有问题的统计信息。

EXP-00091: 正在导出有问题的统计信息。

EXP-00091: 正在导出有问题的统计信息。

EXP-00091: 正在导出有问题的统计信息。

EXP-00091: 正在导出有问题的统计信息。

导出成功终止, 但出现警告。

C:\Documents and Settings\Administrator>

Linux环境下：

1、

exp user1/password tables=table1 rows=y indexes=y compress=y

buffer=65536 feedback=100000 file=/home/test1/test1.dmp log=/home/test1/test1.log QUERY="WHERE

name='zhangsan'"

报错：

LRM-00101: unknown parameter name 'name'

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for

help

EXP-00000: Export terminated unsuccessfully

2、

exp user1/password tables=table1 rows=y indexes=y compress=y

buffer=65536 feedback=100000 file=/home/test1/test1.dmp log=/home/test1/test1.log QUERY=\"WHERE

phonenum\='18754733335'\"

输出：

Export: Release 9.2.0.4.0 - Production on Fri Dec 31 10:42:59

2010

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 -

Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production

Export done in AL32UTF8 character set and AL16UTF16 NCHAR

character set

About to export specified tables via Conventional Path ...

. . exporting

table table1

1 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

Export terminated successfully with warnings.