今天在生产库上用exp导出一张临时表,环境是10.2.0.4.0 64bit AIX 6.1,遇到了以下错误:
About to export specified table via Conventional Path ...
. . exporting table TMP_CLSLEVELDATA_WY_5
. exporting foreign function library names for user JFY
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 904 encountered
ORA-00904: : invalid identifier
EXP-00000: Export terminated unsuccessfully
. . exporting table TMP_CLSLEVELDATA_WY_5
. exporting foreign function library names for user JFY
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 904 encountered
ORA-00904: : invalid identifier
EXP-00000: Export terminated unsuccessfully
导出的与语句为:
exp abc/abc file=tmp.dmp log=tmp.log tables=
TMP_CLSLEVELDATA_WY_5
按理说,命令已经是最小化参数设置了,没理由写错的,查找了半天文档,发现原来是因为导出用户没有dbms_java包的执行权限导致的