Re: [Q] how to check database has been upgrade to 9.2.0.8???

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Thu, 15 Mar 2007 09:52:28 -0700
Message-Id: <1173977548.2749.1179647875@webmail.messagingengine.com>

dba_registry would be one way to go as someone else suggested .. Also, if you had spooled the catpatch.sql then you would find the message about component(s) upgrade at the end .. It is advisable to do a set echo on, and set time/timing on prior to running any catpatch.sql/catupgrd.sql since the spool file it generates will be of lot of help especially if you are running into ORA- errors and it would pinpoint which statement(s) failed.

HTH
GovindanK
>
> dba1 mcc wrote:
>> I have a database which I created it on 9.2.0.1. Recently I upgraded ORACLE software from 9.2.0.1 to 9.2.0.8. I can NOT remember I upgrade that database or not?
>>
>> Does there has way to check database has been upgrade or not?
>>
>> Thanks.
>>
>> We won't tell. Get more on shows you hate to love
>> (and love to hate): Yahoo! TV's Guilty Pleasures list.
>

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

Received on Thu Mar 15 2007 - 11:52:28 CDT