Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Mon Mar 12 2007 - 12:23:35 CDT
![]() |
![]() |