MYSQL网站制作之EXP-00008: ORACLE error 904 encounte...
这种服务也提供了足够的监控功能来跟踪性能和使用情况，在问题发生时将发出通知并生成一定深度的分析报告。error|oracle|办理【毛病情形】
$expwmap/pass@jackeydb
Export:Release8.1.7.4.0-ProductiononFriOct811:28:372004
(c)Copyright2000OracleCorporation.Allrightsreserved.
Connectedto:Oracle9iRelease9.2.0.1.0-Production
JServerRelease9.2.0.1.0-Production
Enterarrayfetchbuffersize:4096>
Exportfile:expdat.dmp>host
(2)U(sers),or(3)T(ables):(2)U>u
Exportgrants(yes/no):yes>
Exporttabledata(yes/no):yes>
Compressextents(yes/no):yes>
ExportdoneinWE8ISO8859P1charactersetandUTF8NCHARcharacterset
serverusesZHS16GBKcharacterset(possiblecharsetconversion)
.exportingpre-schemaproceduralobjectsandactions
.exportingforeignfunctionlibrarynamesforuserWMAP
.exportingobjecttypedefinitionsforuserWMAP
AbouttoexportWMAPsobjects...
.exportingdatabaselinks
.exportingsequencenumbers
.exportingclusterdefinitions
.abouttoexportWMAPstablesviaConventionalPath...
EXP-00008:ORACLEerror904encountered
ORA-00904:"SPOLICY":invalididentifier
EXP-00000:Exportterminatedunsuccessfully
$
【办理办法一】
BookmarkGotoEnd
fact:OracleServer-EnterpriseEdition
symptom:ORA-00904:Invalidcolumnname
symptom:EXP-00008:ORACLEerror%sencountered
cause:Thepackageismissing,invalidorcorrupt
fix:
HowtohandleORA-00904errorsonExport
========================================
Whenrunningfulldatabaseexportthefollowingerrorswillbereturned:
exp80user/passwordfull=yfile=D:DB-BackupORCLexpORCL.dmp
log=D:DB-BackupORCLexpORCL.logconsistent=ybuffer=40960000
EXP-00008:ORACLEerror904encountered
ORA-00904:invalidcolumnname
TogetacluewhathasforcetheseORA-00904message,followthefollowing
steps:
1.Connectasprivilegeduserandrunthefollowingcommandinsidean
SQLPLUSsession:
SQL>altersystemsetevents=904tracenameerrorstack;
--------------------------------Note------------------------------------
ThiseventwillworkstartingwithOracle8i.IfrunningaOracledatabase
versionbelowOracle8i,youllgetORA-02065errorsreturned,when
specifyingthisevent.InOracleversionsbelow8iyoullhavetoinsert
thefollowingentryintoINIT.ORA
event="904tracenameerrorstack"
--------------------------------------------------------------------------
2.RetrytheFULLexport.WhentheORA-00904occurs,atracefilewillbe
writtentothestoragelocationspecifiedbytheINIT.ORAparameter
user_dump_dest.AssoonastheORA-00904hasbeenreturnedtoyour
exportsession,youcanaborttheexportandexaminethetraceinformation.
3.Disableeventtracingbyrunningthefollowingcommand:
SQL>altersystemsetevents=904tracenameerrorstackoff;
OnOracleversionsbelow8.1.5returntheevententryfromINIT.ORA
4.Examinethetracefile:
***SESSIONID:(9.3)2001.11.21.15.28.00.494
***2001.11.21.15.28.00.494
ksedmp:internalorfatalerror
ORA-00904:invalidcolumnname
CurrentSQLstatementforthissession:
SELECTfname,fsize,maxextend,incFROMsys.exu8filWHEREtsid=:1
===========
a)aproblemwithobjectEXU8FILhasbeendetected
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Inthisexample,theresaproblemwiththeEXE8FILview.Toexamine,
whetherthisobjectexist,runthefollowingcommand:
SQL>selectowner,object_name,object_type,object_id,status
fromdba_objects
whereobject_name=EXU8FIL;
IftheproblemisontheEXU8FILobjectyousimplycanrecreatethe
objectbyrunningtheCATEXP.SQLscript.
b)aproblemwithobjectDBMS_JAVAorDBMS_JAVA_TEST
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ksedmp:internalorfatalerror
ORA-00904:invalidcolumnname
CurrentSQLstatementforthissession:
SELECTSYNNAM,DBMS_JAVA.LONGNAME(SYNNAM),DBMS_JAVA.LONGNAME(SYNTAB),...
OnsystemswheretheJavaServerhasbeeninstalledthetracefilecould
containinformationonafailingselectstatementonDBMS_JAVApackages.
ForreferenceonfixingerrorsrelatingtoDBMS_JAVA,pleasefollow
<Note:1017276.102>.
【办理办法二】
Ifthiserror(ORA-904invalidcolumnname)occursafterapplyingapatch,thiswouldprobablyfixtheproblem.
1.First,runCATEXPasINTERNAL.Thenretrytheexport.Oftentimesthiswillfixtheproblemandthenexportwillrunwithouterror.ThereasonbeingaproblemwithobjectEXU8FILviewhasbeendetected.
Toexamine,whetherthisobjectexist,runthefollowingcommand:
SQL>selectowner,object_name,object_type,object_id,status
fromdba_objects
whereobject_name=EXU8FIL;
IftheproblemisontheEXU8FILobjectyousimplycanrecreatetheobjectbyrunningtheCATEXP.SQLscript.
通过支付一定费用，客户可以得到优先的24/7支持，访问内容丰富的在线知识库和联系一个专门的技术负责经理。 微软对CLR作了大篇幅的宣传，这是因为数据库产品终于融入.net体系中。最开始我们也是狂喜，感觉对象数据库的一些概念可以实现了。 在select语句中可以使用groupby子句将行划分成较小的组，然后，使用聚组函数返回每一个组的汇总信息，另外，可以使用having子句限制返回的结果集。 多走走一此相关论坛，多看一些实例开发，多交流0经验，没什么的，我也是刚学没多久!加油 如安全管理、备份恢复、性能监控和调优等，SQL只要熟悉基本操作就可以，只要程序设计部分只要稍加了解即可（如存储过程、触发器等）。 我是新手，正在学习数据库和操作系统，深感理论的泛广，唯有一步一步来，但是又感觉时间不够，收集了很多资料却总是没能认真的看完，希望有一个讨论板块，大家共同解决，共同分享，共同努力 我们学到了什么？思考问题的时候从表的角度来思考问 现在是在考虑:如果写到服务器端,我一下搞他个10个存储过程导过去,那久之服务器不就成垃圾箱了吗?即便优化了我的中间层. 理解了存储结构，再阅读下性能优化的章节基本上会对sqlserver有个清晰地认识
页:
[1]