oracle exp query使用解決-LRM-00101: 未知的參數名

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.

from：http://blog.sina.com.cn/s/blog_57bf66e80100oceo.html