Re: How can I identify the database

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Thu, 24 Sep 2009 14:57:42 +0300
Message-ID: <6e49b6d00909240457l65bed73fk48d47fbb0d2c5c44_at_mail.gmail.com>

Either from v$version, which seems to be accessible by public. Or using Sqlplus
When connected to enterprise edition it explicitly says so: Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options

When connected to standard edition it doesn't say anything: Connected to:
Oracle Database 11g Release 11.2.0.1.0 - Production

When connected to express edition it also explicitly says so, but unfortunately I haven't any instance handy. But you will notice that ;)

Gints Plivna
http://www.gplivna.eu

2009/9/24 Eriovaldo Andrietta <ecandrietta_at_gmail.com>:
> Hi,
>
>  How can I identify if the database is an Oracle Enterprise Version or an
> Oracle Express Version.
>  Consider that I don´t have access privilige in the v$database and others
> v$.
>
>   Is there another way ?
>
> Regards
> Eriovaldo
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 24 2009 - 06:57:42 CDT