RE: possible Bug in Oracle 9.2.0.2

2003-08-14 Thread MacGregor, Ian A.
I've no experience with Peoplesoft and Oracle 9, but .. Try setting the following parameters optimizer_features_enable = 8.1.6 As I recall this prevented Oracle from incorrectly tossing out some subselects. I'm not sure if it is even valid in 9iR2 _ignore_desc_in_index = TRUE Not setting

RE: possible Bug in Oracle 9.2.0.2

2003-08-14 Thread Jamadagni, Rajendra
Title: RE: possible Bug in Oracle 9.2.0.2 You it is a bug alter session|system set _unnest_subquery=false / Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly

RE: possible Bug in Oracle 9.2.0.2

2003-08-14 Thread Browett, Darren
Title: Message That fixed it, thank you. I still haven't heard from oracle support yet. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 4:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: possible Bug

RE: possible Bug in Oracle 9.2.0.2

2003-08-14 Thread Freeman Robert - IL
Did you open an iTar with Oracle? If so, what severity was it logged at? How you answer certain questions on the iTAR form will impact the severity of the tar, and as a result the time for responses from Oracle. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent:

Re: possible Bug in Oracle 9.2.0.2

2003-08-09 Thread Wolfgang Breitling
Can you please list select emplid, empl_rcd, effdt, effseq, empl_status from ps_job where emplid = '3442' At 03:34 PM 8/6/2003 -0800, you wrote: While I am waiting for oracle support to respond to my tar update (2nd callback) I am just wondering if anybody has found this problem. We have the

RE: possible Bug in Oracle 9.2.0.2

2003-08-08 Thread Browett, Darren
Title: Message I already have :) -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 12:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: possible Bug in Oracle 9.2.0.2 Tell them ... Raj

RE: possible Bug in Oracle 9.2.0.2

2003-08-07 Thread Jamadagni, Rajendra
! -Original Message-From: Browett, Darren [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: possible Bug in Oracle 9.2.0.2 That fixed it, thank you. I still haven't heard from oracle support yet