首页 > 代码库 > ora-00600 to check
ora-00600 to check
Hi ,
Let us know issue reproducibility executing following statement from command prompt: SELECT "ID","IMO_CODE","I_E_FLAG","DECLARE_DATE","CNTR_ID","CREATED_DATE" FROM "SUP_CONTAINER" "SC" WHERE "DECLARE_DATE" IS NULL AND "I_E_FLAG"=‘I‘ AND "CREATED_DATE">:1-3 AND "IMO_CODE" IS NOT NULL AND "IMO_CODE"=:2 AND "CNTR_ID"=:3 ----- Bind Info (kkscoacd) ----- Bind#0 oacdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00 oacflg=00 fl2=1000000 frm=00 csi=00 siz=168 off=0 kxsbbbfp=9fffffffbf53ef20 bln=07 avl=07 flg=05 value="http://www.mamicode.com/5/10/2017 8:52:2"<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< :1 Bind#1 oacdty=01 mxl=32(27) mxlc=00 mal=00 scl=00 pre=00 oacflg=02 fl2=1000000 frm=01 csi=873 siz=0 off=8 kxsbbbfp=9fffffffbf53ef28 bln=32 avl=09 flg=01 value="http://www.mamicode.com/UN9702132"<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< :2 Bind#2 oacdty=01 mxl=128(33) mxlc=00 mal=00 scl=00 pre=00 oacflg=02 fl2=1000000 frm=01 csi=873 siz=0 off=40 kxsbbbfp=9fffffffbf53ef48 bln=128 avl=11 flg=01 value="http://www.mamicode.com/DFSU2296472"<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< :3 Also let us know following details: 01. Upload DDL of "SUP_CONTAINER" object. 02. What are recent changes OS / hardware / Database before these errors? 03. Please provide following query results: conn /as sysdba set markup html on spool OutPut.html select * from dba_registry; select * from dba_objects where status=‘INVALID‘; select * from registry$history; select substr(action_time,1,30) action_time,substr(id,1,10) id,substr(action,1,10) action,substr(version,1,8) version,substr(BUNDLE_SERIES,1,6) bundle,substr(comments,1,20) comments from registry$history; spool off Thanks Girish |
ora-00600 to check
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。