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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find Oracle Version?

Re: How to find Oracle Version?

From: Rick Losey <rlosey_at_hotmail.com>
Date: Tue, 8 Jun 1999 20:34:44 -0600
Message-ID: <Aqk73.1614$N3.56946@news.uswest.net>


The best way that I know is to bring up the Oracle installer. On all versions 8.0.5 or earlier, you look in the right list box (Installed components) and just read the version number. 8.1.5 is a little different. You bring up the universal installer, and then you almost have to know where to find the component because it is arranged in a tree structure. Once you find it, just read the version number. If you call Oracle support, this is what they make you do.

Rick
Stephen Harris wrote in message <7jincn$m06$1_at_nebula.mpn.com>...
>Valent Levente (valentl_at_szabinet.hu) wrote:
>: The v$version might contain irrelevant version information.
>: use sm$version, instead :
>
>No - do not use sm$version because it is not always (at all?) correct.
>
> > select * from sm$version;
>
> VERSION_T VERSION_NUMBER CREATED
> --------- -------------- ---------
> 7.3.2.0.0 120594432 25-MAR-99
>
> > select * from v$version where banner like 'Oracle%';
>
> BANNER
> ----------------------------------------------------------------
> Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
>
>
>Interesting...
>
>/oracle/app/oracle/product/8.0.5/rdbms/admin/catsvrmg.sql includes the
lines
>
> create or replace view sys.sm_$version as
> select '7.3.2.0.0' version_text, 120594432 version_number, created
> from sys.dba_objects where owner = 'SYS' and object_name =
'SM_$VERSION';
> grant select on sys.sm_$version to public;
> drop public synonym sm$version;
> create public synonym sm$version for sys.sm_$version;
>
>I don't think you can trust this for anything :-)
>
>--
>
>rgds
>Stephen
Received on Tue Jun 08 1999 - 21:34:44 CDT

Original text of this message

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