MYSQL网站制作之EXP-00008: ORACLE error 904 encounte...

这种服务也提供了足够的监控功能来跟踪性能和使用情况，在问题发生时将发出通知并生成一定深度的分析报告。error|oracle|办理
【毛病情形】

[oracle@ccdevsvradmin]$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
[oracle@ccdevsvradmin]$


【办理办法一】
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有个清晰地认识