合 ORA-00904: : invalid identifier
Tags： Oracle
客户反映将JFY用户下的某个表的字段由VARCHAR2(50)调整为VARCHAR2(100)之后，执行exp导出时收到如下的报错：
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Note: grants on tables/views/sequences/roles will not be exported
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user JFY
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 904 encountered
ORA-00904: : 标识符无效 <<<< 两个冒号之间是空格，并没有具体的标识符，这跟以前遇到过的ORA-00904报错不同。
EXP-00000: Export terminated unsuccessfully
客户的exp导出操作是在数据库服务器段完成的，且调度脚本已经稳定运行了1年多，在调整字段长度后出现该报错。脚本中exp的语句如下：
exp jfy/xxx BUFFER=8192 FILE=$bakdir$myfile.dmp ROWS=y COMPRESS=y CONSTRAINTS=y GRANTS=n INDEXES=y LOG=$bakdir$mylogfile
jfy是个DBA权限的用户。
根据以上的错误情况，在MOS中找到如下符合描述的文章：
Errors EXP-8 ORA-904 During Export (Doc ID 1091927.1)
In this Document
