RE: quote a few reasons to downgrade a database release

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Mon, 1 May 2006 14:17:50 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA65036588D2@25exch1.vicorpower.vicr.com>

Stephen,

Excuse me, but:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production JServer Release 9.2.0.7.0 - Production

Current date/time

05/01/06 14:16

Session altered.

Rhdb12(R):9.2:DATAMAN> set pause on
Rhdb12(R):9.2:DATAMAN> SELECT /*+ rule */ rownum, t.* , m.fats_status bin_type
2 from module_master m, tmp_tewebdev t 3 where bin = 'Device Passed'

  4    and t.vector = 'FT Pre Term Block' 
  5    and t.part_number = 'V24A28M400BL' 
  6    and t.tester = 'COGLINE' 
  7    and m.module_id = t.module_id

8 order by start_date ASC
9 ;
Press ENTER/Return for more .....>

ROWNUM HRIDX MODULE_ID STATUS BIN_ID

---------- ---------------- ------------- ---------- ----------
BIN                                      PART_NUMBER
SERIAL_NUMBER        START_DAT
---------------------------------------- --------------------
-------------------- ---------
  DURATION  TESTER_ID TESTER                VECTOR_ID
---------- ---------- -------------------- ----------
VECTOR                                                       PRODUCT
WORK_ORDER            SLOT
------------------------------------------------------------ -----------

--------------- ----------
FIX BI
--- --

         1 1UJU4DC1248GTD0O 2453838:85688          1          1
Device Passed                            V24A28M400BL
01060412210644       17-APR-06
    25.894        121 COGLINE                     100
FT Pre Term Block                                            N/A (SPEED)
PRN284034              934

N/A

         2 1UJU4DC1248GUM0P 2453838:85691          1          1
Device Passed                            V24A28M400BL
01060412210635       17-APR-06
    25.319        121 COGLINE                     100
FT Pre Term Block                                            N/A (SPEED)
PRN284034              934

N/A

         3 1UJU4DC1248H1K0R 2453838:85697          1          1
Device Passed                            V24A28M400BL
01060412210627       17-APR-06
    26.627        121 COGLINE                     100
FT Pre Term Block                                            N/A (SPEED)
PRN284034              934

N/A

         4 1UJU4DC1248H420T 2453838:85690          1          1
Device Passed                            V24A28M400BL
01060412210634       17-APR-06
    26.978        121 COGLINE                     100

Obviously the rule hint does still work.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nirmalya Das Sent: Monday, May 01, 2006 2:10 PM
To: stephenbooth.uk_at_gmail.com
Cc: vikramsingh120_at_gmail.com; oracle-l_at_freelists.org Subject: Re: quote a few reasons to downgrade a database release

Along the same line, I had a situation where the application vendor used "RULE"
hint using 9.2.0.5 and 9.2.0.7 doesn't allow that.

Quoting stephen booth <stephenbooth.uk_at_gmail.com>:

> On 01/05/06, vikram singh <vikramsingh120_at_gmail.com> wrote:
>> Hello All,
>> Can anyone out there provide me some valid reasons when a
database
>> would need to be downgraded?
>> any reason will be helpful?
>> Thanks in advance.
>>
>>
>
> The only one I've personally run into in production is: Application
> worked on the old version of Oracle, fails on the new, turns out it
> uses a feature that has been removed and the application vendor
> doesn't have a version of their software that works with the current
> of Oracle or is no longer in business so you're stuck and the
> department won't or cannot replace the application.
>
> Stephen
>
> --
> It's better to ask a silly question than to make a silly assumption.
>
> http://stephensorablog.blogspot.com/
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 01 2006 - 13:17:50 CDT