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

Check

select cname, cid, version from registry$ where cid='CATALOG'

It should give you  

CNAME                          CID        VERSION

------------------------------ ---------- ------------------------------

Oracle9i Catalog Views         CATALOG    9.2.0.8.0

 

You can also use this to check the detailed status of your upgrade - what was upgraded and if it is valid.  

HTH

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Williams Sent: Monday, March 12, 2007 1:01 PM
To: mccdba1_at_yahoo.com
Cc: oracle-l_at_freelists.org
Subject: Re: [Q] how to check database has been upgrade to 9.2.0.8???  

Dba1,  

Try logging in with SQL*Plus. Usually that identifies the database version.  

Dennis Williams  

On 3/12/07, dba1 mcc <mccdba1_at_yahoo.com> wrote:

I have a database which I created it on 9.2.0.1 <http://9.2.0.1/> . Recently I upgraded ORACLE software from 9.2.0.1 <http://9.2.0.1/> to 9.2.0.8 <http://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 <http://us.rd.yahoo.com/evt=49980/*http:/tv.yahoo.com/collections/265%0A
>

(and love to hate): Yahoo! TV's Guilty Pleasures list. <http://us.rd.yahoo.com/evt=49980/*http:/tv.yahoo.com/collections/265%0A
>
 

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