odd error 2006-01-24 - By Michael.Coll-Barth@(protected)
Christian, David,
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
|
|
