Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to find version number of the database
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-lReceived on Tue Sep 05 2006 - 05:39:07 CDT