Re: Oracle Version

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 4 Jun 2003 22:17:29 +1000
Message-ID: <c9lDa.49552$1s1.648616@newsfeeds.bigpond.com>

"Michael McMahon" <mcmahonm_at_mindspring.com> wrote in message news:bbjdqj$vmb$1_at_slb5.atl.mindspring.net...
> 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.
>

Hi Mike

Check out dba_registry.

Cheers

Richard Received on Wed Jun 04 2003 - 07:17:29 CDT