RE: [Q] how to check database has been upgrade to 9.2.0.8???
- From: rajendra.pande@xxxxxxx
- To: <oracledba.williams@xxxxxxxxx>, <mccdba1@xxxxxxxxx>
- Date: Mon, 12 Mar 2007 13:23:35 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dennis Williams
Sent: Monday, March 12, 2007 1:01 PM
To: mccdba1@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> 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
>
Other related posts:
