Re: verifiing 8.1.7.4.1 upgrade to 8.1.7.4.x

From: Mark Bole <makbo_at_pacbell.net>
Date: Sun, 18 Apr 2004 01:39:03 GMT
Message-ID: <X_kgc.37966$gD3.1885@newssvr29.news.prodigy.com>

Ivette Dumois wrote:
> I have upgraded our test 8.1.7.4.1 database to 8.1.7.4.13. I would
> like to verify this fact.
>
> In the readme it does state that all the products will not display the
> version number 8.1.7.4.13, because it's a cummulative patch.
>
> I would like to see at least one file with the version number greater
> than 8.1.7.4.1
>
> querying the database, v$instance still yields 8.1.7.4.1
>
> Any ideas?
>
> thanks

You could also try V$VERSION... but I doubt you'll see that fifth level of revision shown.

If you had a specific bug that was supposed to be fixed by the upgrade, test for that. Otherwise, your effort would be better spent on an Oracle 9i or Oracle 10g upgrade... since 8i is de-supported.

--Mark Bole Received on Sat Apr 17 2004 - 20:39:03 CDT