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

From: Mercadante, Thomas F $LABOR$ <Thomas.Mercadante_at_labor.state.ny.us>
Date: Mon, 12 Mar 2007 13:11:28 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08C10@EXCNYSM0A1AJ.nysemail.nyenet>

You can also run:

select comp_name, version, status from dba_registry;

COMP_NAME                          VERSION                STATUS

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

Oracle9i Catalog Views              9.2.0.7.0                      VALID

Oracle9i Packages and Types    9.2.0.7.0                      VALID

JServer JAVA Virtual Machine    9.2.0.7.0                      VALID

Tom

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of A. Coskan Gundogar Sent: Monday, March 12, 2007 12:25 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???

i think this can solve your problem

SQL> select version from v$instance;

VERSION

10.2.0.1.0

SQL> On 3/12/07, dba1 mcc <mccdba1_at_yahoo.com> 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 <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

Received on Mon Mar 12 2007 - 12:11:28 CDT