Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find Oracle Version?
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
![]() |
![]() |