在导出时报exp-00056

[ha00012]

exp userid=gest/gest tables=mog query=\" where logid>=41699165 and logid<46119753 \" file=/db2/mana.dmp rows=y indexes=n compress=y
在导出数据时报没有这个文件..是不是不能这样写
-bash: 46119753": No such file or directory



exp userid=gest/test rows=y indexes=n compress=y tables=mlog query=\" where logid>=41699165 \" file=/db2/mana.dmp
Export: Release 10.2.0.4.0 - Production on Mon Sep 17 06:35:59 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in UTF8 character set and AL16UTF16 NCHAR character set
Note: indexes on tables will not be exported
About to export specified tables via Conventional Path ...
. . exporting table MLOG
EXP-00056: ORACLE error 920 encountered
ORA-00920: invalid relational operator
Export terminated successfully with warning

在导出数据时报exp-00056

[ha00012]

将参数放在一个文件中..再执行exp parfile=exp.txt就可以..因为这样要用到转义符..

[软件钢琴师]

改变oracle这个文件的属性
chmod 6751 $ORACLE_HOME/bin/oracle试试