Oracle exp Query use resolution-LRM-00101: Unknown Parameter Name

In Windows:

 

C: \ Documents ents and Settings \ Administrator>

C: \ Documents ents and Settings \ Administrator>

C: \ Documents ents and Settings \ Administrator> exp user/password @ Oracle tables = Table1 rows = y indexes = y compress = y buffer = 65536 feedback = 100000File = D: \ test1.dmp log = D: \ test1.log query = "where name = 'hangsan '"

LRM-00101: Unknown Parameter Name 'phonenum'

 

EXP-00019: processing parameter failed, type 'exp help = y' for help information

EXP-00000: Export termination failed

 

C: \ Documents ents and Settings \ Administrator> exp user/password @ Oracle tables = Table1 rows = y indexes = y compress = y buffer = 65536 feedback = 100000File = D: \ test1.dmp log = D: \ test1.log query = 'where name = "zhangsan "'

 

Export: Release 10.2.0.1.0-production on Friday December 31 10:40:54 2010

 

Copyright (c) 1982,200 5, Oracle.All rights reserved.

 

 

Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production

With the partitioning, OLAP and Data Mining options

The zhs16gbk and al16utf16 nchar character sets have been exported.

 

To export the specified table, use the regular path...

... Exporting table...       Table1

Exported                                                           
1 line

EXP-00091: Exporting problematic statistics.

EXP-00091: Exporting problematic statistics.

EXP-00091: Exporting problematic statistics.

EXP-00091: Exporting problematic statistics.

EXP-00091: Exporting problematic statistics.

EXP-00091: Exporting problematic statistics.

EXP-00091: Exporting problematic statistics.

EXP-00091: Exporting problematic statistics.

The export is successfully terminated, but a warning is displayed.

 

C: \ Documents ents and Settings \ Administrator>

 

In Linux:

 

1,

Exp user1/password tables = Table1 rows = y indexes = y compress = y buffer = 65536 feedback = 100000File =/home/test1/test1.dmp log =/home/test1/test1.log query = "where name = 'hangsan '"

 

Error:

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 = 100000File =/home/test1/test1.dmp log =/home/test1/test1.log query = \ "where phonenum \ = '000000 '\"

 

Output:

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

 

Copyright (c) 1982,200 2, 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