Thanks this is correct answer.
Actually, I did tried v$database, v$instance and
v$version before post to this group. V4database,
v$version and V$instance show ORACLE software version
NOT database version.
By the way someone criticize my poor english, I am
very sorry about that if it hurt to anyone. if you
are like me English is NOT your first language,
someone criticise you same word what is your feeling.
Thanks.
- "Mercadante, Thomas F (LABOR)"
<Thomas.Mercadante_at_labor.state.ny.us> wrote:
> 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
> >
>
Expecting? Get great news right away with email Auto-Check.
Try the Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 12 2007 - 12:20:34 CDT
