今天在导出数据库表时遇到 ORA-00904: : invalid identifier 错误
数据库表字段也没有关键字冲突,查半天不知道怎么回事
[oracle@fxdb01 tmp]$ exp user/passwd tables=t_ddyy file=/tmp/dong/t_ddyy.dmp log=/tmp/dong/t_ddyy.log statistics=none indexes=n buffer=1000000
Export: Release 11.2.0.4.0 - Production on Fri Feb 7 11:35:55 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, Oracle Label Security and Oracle Database Vault options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
Note: indexes on tables will not be exported
About to export specified tables via Conventional Path ...
. . exporting table t_DDYY
EXP-00008: ORACLE error 904 encountered
ORA-00904: : invalid identifier
Export terminated successfully with warnings.
[oracle@fxdb01 tmp]$
受到高手指点,解决办法::
grant execute on DBMS_JAVA to user;