Re: How to find version number of the database

  • From: "Jurijs Velikanovs" <j.velikanovs@xxxxxxxxx>
  • To: pjhoraclel@xxxxxxxxx
  • Date: Tue, 5 Sep 2006 11:39:07 +0100

select * from dba_registry;

On 9/5/06, Peter Hitchman <pjhoraclel@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2006