Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to find version number of the database

Re: How to find version number of the database

From: Jurijs Velikanovs <j.velikanovs_at_gmail.com>
Date: Tue, 5 Sep 2006 11:39:07 +0100
Message-ID: <d6f0def50609050339l20f1b8b4gd6c388a60edcda31@mail.gmail.com>


select * from dba_registry;

On 9/5/06, Peter Hitchman <pjhoraclel_at_gmail.com> wrote:
> Hi,
> My scenario is:
>
> Duplicated a 9.2.0.6 database to a server running a Oracle home patched up
> to 9.2.0.7.
>
> Now, assuming I could not access the source, how would I find out the
> original version of the database?
> I tried the dbms_utility.db_version, but that reported 9.2.0.7.0
> So is there a way to find out the version of the database, as opposed to
> the version of the instance being used to connect to it?
>
> Regards
>
> Pete

-- 
Yury
+44 7738 013090 (GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 05 2006 - 05:39:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US