Re: Oracle Version

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 4 Jun 2003 23:15:18 -0700
Message-ID: <92eeeff0.0306042215.e9e2342@posting.google.com>

Hans Forbrich <forbrich_at_telusplanet.net> wrote in message news:<3EDEA3A4.5B62149A_at_telusplanet.net>...
> Michael McMahon wrote:
>
> > Is there any way to determine the actual patch level of a database server??
> > When querying the V$VERSION view it returns Oracle Enterprise Edition
> > Release 8.0.6.1.0 - Production, however I know that this server has been
> > patched to 8.0.6.1.2.
> >
> > Any ideas would be appreciated.
> >
> > Mike
>
> I believe I remember reading a metalink note that describes the numbering
> convention. (Anyone have the note # handy?)
>
> Also, IIRC, the convention has been revised with the onset of 9i.

Why not just get the exact patchset information from Oracle Inventory/PatchSets/oracle.server directory!

Regards
/Rauf Sarwar Received on Thu Jun 05 2003 - 01:15:18 CDT