Re: patch level and version of db?

But, according to Metalink docs,not ALL patches are reflected in the version # - some do not update any of those numbers ..

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>
>"Roger" <rwestbrook_at_dollargeneral.com> wrote in message
>news:16e6a39.0111140832.47afb3d8_at_posting.google.com...
>> How can I tell patch level and version of my database?
>>
>> We have 11 different installations at various patch levels. I'm
>> looking for a method I can give to our developers to enable them to
>> tell what db version and patch level a given instance is at. Is there
>> a table or o/s file they can inquire against to get the current db
>> version and patch level?
>>
>> Thanks in advance!
>>
>> Oh and we're talking Oracle 8x and 9x databases on Unix systems.
>>
>> Roger Westbrook
>
>select * from v$version.
>The first three digits are the version, the last two the O/S specific patch
>level.
>
>Hth

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Wed Nov 14 2001 - 15:51:32 CST