RE: Analytic bug in 9.2.0.4

2003-12-05 Thread jo_holvoet
of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Analytic bug in 9.2.0.4 You are right Jared. ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [], [], [], [],[], [] this is on oracle 9.2.0.3 Win2k+SP3. Regards, Jp. -Original Message

Re: Analytic bug in 9.2.0.4

2003-12-05 Thread Jonathan Lewis
Fixed in 10. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see

RE: Analytic bug in 9.2.0.4

2003-12-05 Thread Jamadagni, Rajendra
works on 9202 but that's not what you wanted to hear ... right? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having

RE: Analytic bug in 9.2.0.4

2003-12-05 Thread nelson . petersen
The same thing occurs on OpenVMS on version 9.2.0.4 of Oracle. Nelson -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, December 04, 2003 7:29 PMTo: Multiple recipients of list ORACLE-LSubject: Analytic bug in 9.2.0.4While playing around

Re: Analytic bug in 9.2.0.4

2003-12-05 Thread Mladen Gogala
Do you know when will this fabulous version 10 be available for download? On 12/05/2003 04:14:34 AM, Jonathan Lewis wrote: Fixed in 10. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who

RE: Analytic bug in 9.2.0.4

2003-12-05 Thread Brian McGraw
It wasn’t fixed in my version of 9.2.0.3: ERROR at line 11: ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [], [], [], [], [], [] 9.2.0.3, 32-bit. Solaris 8. Brian - | Brian McGraw  -+-  Senior DBA | | mailto:[EMAIL PROTECTED] |

RE: Analytic bug in 9.2.0.4

2003-12-05 Thread Hrncirik, Debbie
It works fine for me - 9.2.0.3, 64-bit, Solaris 9 -Debbie -Original Message- Brian McGraw Sent: Friday, December 05, 2003 8:09 AM To: Multiple recipients of list ORACLE-L It wasn't fixed in my version of 9.2.0.3: ERROR at line 11: ORA-00600: internal error code, arguments:

RE: Analytic bug in 9.2.0.4

2003-12-05 Thread Jared . Still
] cc: Subject:RE: Analytic bug in 9.2.0.4 works on 9202 but that's not what you wanted to hear ... right? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly

RE: Analytic bug in 9.2.0.4

2003-12-05 Thread Jared . Still
-L [EMAIL PROTECTED] cc: Subject:RE: Analytic bug in 9.2.0.4 It works fine for me - 9.2.0.3, 64-bit, Solaris 9 -Debbie -Original Message- Brian McGraw Sent: Friday, December 05, 2003 8:09 AM To: Multiple recipients of list ORACLE-L It wasn't fixed in my version

RE: Analytic bug in 9.2.0.4

2003-12-05 Thread Browett, Darren
Title: Message Just to add to the list Tru64/Trucluster 5.1b - 9.2.0.4 rac from v$pga_target_advice_histogram *ERROR at line 11:ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [],[], [], [], [], [] -Original Message-From: [EMAIL PROTECTED]

Analytic bug in 9.2.0.4

2003-12-04 Thread Jared . Still
While playing around with SQL for some PGA scripts, I managed to create some SQL that will consistently cause ORA-600 [kkqwrm_noref: COLFDNF set] This appears to be Bug # 2507421, which was supposedly fixed in 9.2.0.3. Here's the SQL: select pga_target_for_estimate ,

RE: Analytic bug in 9.2.0.4

2003-12-04 Thread Prem Khanna J
You are right Jared. ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [], [], [], [],[], [] this is on oracle 9.2.0.3 Win2k+SP3. Regards, Jp. -Original Message- While playing around with SQL for some PGA scripts, I managed to create some SQL that will

Bug in 9.2.0.4

2003-09-22 Thread Munish Bajaj
Hi Listers Any idea about this Bug in 9.2.0.4. If you try "select 'Hello' from dual order by 1 desc;" you may run into the bug. It creates a dump in udump and could disconnect your session. Oracle is creating a one-off patch to fix. The bug is for any order by x, where x i

Re: Bug in 9.2.0.4

2003-09-22 Thread Prem Khanna J
Munish, i posted the same content to the LIST this morning. i tried it on my instance and it happens :(( Jp. 22-09-2003 17:19:39, Munish Bajaj [EMAIL PROTECTED] wrote: Hi Listers Any idea about this Bug in 9.2.0.4. If you try select 'Hello' from dual order by 1 desc; you may run

Re: Bug in 9.2.0.4

2003-09-22 Thread ManojKr Jha
: Sent by: Subject: Bug in 9.2.0.4 [EMAIL PROTECTED] city.com

Re: Bug in 9.2.0.4

2003-09-22 Thread ManojKr Jha
[EMAIL PROTECTED] .co.jp cc: Sent by: Subject: Re: Bug in 9.2.0.4 [EMAIL PROTECTED

Re: Bug in 9.2.0.4

2003-09-22 Thread ManojKr Jha
] Subject: Re: Bug in 9.2.0.4(Document link: ManojKrJha) Can any body try the following in 9.2.0.4 SQL select object_name,object_type,owner from dba_objects where

Re: Bug in 9.2.0.4

2003-09-22 Thread jo_holvoet
ORACLE-L [EMAIL PROTECTED] cc: Subject:Bug in 9.2.0.4 Hi Listers Any idea about this Bug in 9.2.0.4. If you try select 'Hello' from dual order by 1 desc; you may run into the bug. It creates a dump in udump and could disconnect your session. Oracle is creating

RE: Bug in 9.2.0.4

2003-09-22 Thread Nigel Bishop
in udump, but it does write to core.log in cdump. regards Jo Munish Bajaj [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/22/2003 10:19 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Bug in 9.2.0.4

RE: Bug in 9.2.0.4

2003-09-22 Thread Nigel Bishop
to core.log in cdump. regards Jo Munish Bajaj [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/22/2003 10:19 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Bug in 9.2.0.4 Hi Listers Any idea about

Re: RE: Bug in 9.2.0.4

2003-09-22 Thread Prem Khanna J
Ohhh ! ...i don't find 3110923 patch fix for Ms-Win :( 22-09-2003 20:39:52, Nigel Bishop [EMAIL PROTECTED] wrote: Ooops - Sorry Monday morning cut paste error - patch number should read 3110923 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET:

Bug in 9.2.0.4 when order by constant desc

2003-09-21 Thread Prem Khanna J
Hi all, Got the info' below from www.dba-village.com and thought of sharing it with u guys. If you try select 'Hello' from dual order by 1 desc; you may run into the bug. It creates a dump