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

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


Other related posts: