Thanks, I tried MetaLink, but it just tells me that there is a problem. I am not a DBA, just a lowly user. My DBA had already opened a TAR with support. The plan is to apply a security patch and a patch for this error sometime in February. Maybe I just haven't figured out how to use MetaLink properly.
The reason I ask was more out of curiosity; there seems to be folks on here that know Oracle better than Oracle. This query was so darn simple that I am still amazed that it could cause an error. I was hoping for a better workaround than a UNION ALL of two queries. Mind you, "where churn_dt in ( '01-jan-2004', '31-dec-2004' )", does not work either.
Michael
-- --Original Message-- -- From: Christian Antognini [mailto:Christian.Antognini@(protected)] Sent: Tuesday, January 24, 2006 3:45 PM To: Coll-Barth, Michael Cc: oracle-l@(protected) Subject: RE: odd error
Michael
Go here http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_ database_id=NOT&p_id=153788.1 and enter qksmmAdjustStatistics1 as first parameter.
HTH Chris
>-- --Original Message-- -- >From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of >Michael.Coll-Barth@(protected) >Sent: 24 January 2006 21:21 >To: oracle-l@(protected) >Subject: odd error > >All, > >I am getting a strange error with the code below. Does anyone have an >explanation? > >thanks, >Michael > > >SQL> select unique market_cd, churn_dt > 2 from eisweb.eis_ret_cmbd_rpt > 3 where ( churn_dt = '01-jan-2004' or churn_dt = '31-dec-2004' ) > 4 -- and market_cd > chr(0) > 5 ; >from eisweb.eis_ret_cmbd_rpt > * >ERROR at line 2: >ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [qksmmAdjustStatistics1], [], [], >[], [], [], [], [] > > >The information contained in this message and any attachment may be >proprietary, confidential, and privileged or subject to the work >product doctrine and thus protected from disclosure. If the reader >of this message is not the intended recipient, or an employee or >agent responsible for delivering this message to the intended >recipient, you are hereby notified that any dissemination, >distribution or copying of this communication is strictly prohibited. >If you have received this communication in error, please notify me >immediately by replying to this message and deleting it and all >copies and backups thereof. Thank you. > >-- >http://www.freelists.org/webpage/oracle-l > -- http://www.freelists.org/webpage/oracle-l
