【充满错误爱情的蜜粉】
[ Oracle @ ccdevsvr admin ] $ expwmap/pass @ jackey db
export:版本8.1.7.4.0-productiononfrioct 8113360283360372004
(c )复制2000 Oracle corporation.all rights reserved。
连接到： Oracle 9i版本9.2.0.1.0-production
jerverrelease9.2.0.1.0-产品
enterarrayfetchbuffersize 33604096
导出文件： exp dat.DMP host
(2) u ) u (秒)，or )3) t ) T(ables ) : (2)2) u
导出授权(是/否) :是
导出可移植数据(是/否) :是
压缩扩展(是/否) :是
exportdoneinwe8iso 8859 P1 charactersetandutf8nchar characters et
serveruseszhs 16 gbk characters et (可配置转换器) )。
. exporting pre-schemaproceduralobjectsandactions
. exportingforeignfunctionlibrarynamesforuserfzdmg/p.exportingobjecttypedefinitionsforuserfzdmg/pabouttoexportwmap ' sobbortwzdmap .
. exporting数据库链接
. exporting sequence numbers
. exporting群集定义
. abouttoexportwmap ' stablesviaconventionalpath .
exp-000083360 Oracle error 904 encountered
ora-00904: ' s策略' : invalid identifier
exp-000003360 exportterminatedunsuccessfully
[oracle@ccdevsvr admin]$
【解决方法1】
Bookmark Go to End
fact : oracleserver -企业版
symptom : ora-009043360 invalid列名称
symptom : exp-000083360 Oracle error % s encountered
cause: The package is missing，invalid or corrupt
fix:
howtohandleora-00904错误报告
=====================================
whenrunningfulldatabaseexportthefollowingerrorswillbereturned :
exp 80 user/password full=y file=d :d B- backuporclexp orcl.DMP
log=d :d B- backuporclexp orcl.log consistent=y buffer=40960000
exp-000083360 Oracle error 904 encountered
ora-00904: invalid column name
togetacluewhathasforcetheseora-00904消息，follow the following
步骤：
1.connectasprivilegeduserandrunthefollowingcommandinsidean
SQLPLUS session:
sqlaltersystemsetevents=' 904 tracenameerrorstack '；
----------------note------------------------------------。
thiseventwillworkstartingwithoracle 8i.ifrunningaoracledatabase
version below Oracle8i，you ' llgetora-02065错误恢复，when
specifyingthisevent.inoracleversionsbelow 8i you ' llhavetoinsert
the following entry into INIT.ORA
event='904 trace name errorstack '
------------- -请参阅
2.retrythefullexport.when theora-00904 occurs，a trace file will be
writtentothestoragelocationspecifiedbytheinit.ora parameter
' user _ dump _ dest '.assoonastheora-00904 hasbeenreturnedtoyour
导出会话，youcanaborttheexportandexaminethetraceinformation。
3.disableeventtracingbyrunningthefollowingcommand 3360
sqlaltersystemsetevents=' 904 tracenameerrorstackoff '；
oracleversionsbelow8.1.5returntheevententryfrominit.ora
4.Examine the跟踪文件：
* * *会话id : (9.3 ) 2001.11.21.15.28.00.494
*** 2001.11.21.15.28.00.494
kse DMP :国际米兰足球俱乐部
ora-00904: invalid column name
currentsqlstatementforthissession :
SELECT fname，fsize，maxextend，incfromsys.ex u8 filwheretsid=:1
===============
a ) aproblemwithobjectexu 8文件维护
~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~
In this example，there ' saproblemwiththeexe8fil view.to examine，
whether this object exist，run the following command:
SQL select owner，object_name，object_type，object_id，status
from dba_objects
where object_name='EXU8FIL '；
iftheproblemisontheexu8filobjectyousimplycanrecreatethe
objectbyrunningthecatexp.SQL脚本。
b ) aproblemwithobjectdbms _ javaordbms _ Java _ test
~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~
kse DMP :国际米兰足球俱乐部
ora-00904: invalid column name
currentsqlstatementforthissession :
SELECT SYNNAM，DBMS_Java.longname，DBMS_Java.longname，syntab，
onsystemswherethejavaserverhasbeeninstalledthetracefilecould
containinformationonafailingselectstatementondbms _ Java包。
forreferenceonfixingerrorsrelatingtodbms _ Java，please follow
1017276.102。
【解决方法2】
ifthiserror (ora-904邀请列名称) occurs after applying a patch，this would probably fix the problem。
1.first runcatexpasinternal.thenretrytheexport.oftentimesthiswillfixtheproblemandthenexportwilrunwithouterrror.thereasout
To examine，whether this object exist，run the following command:
SQL select owner，object_name，object_type，object_id，status
from dba_objects
where object_name='EXU8FIL '；
iftheproblemisontheexu8filobjectyousimplycanrecreatetheobjectbyrunningthecatexp.SQL script.1017276.102
客户端有两个版本的oracle。 更改$ORACLE_HOME和$ORACLE_HOME/lib的方向即可。