Re: How can I identify the database
- From: Subodh Deshpande <subodh_deshpande@xxxxxxxxx>
- To: ecandrietta@xxxxxxxxx
- Date: Thu, 24 Sep 2009 06:44:14 -0700 (PDT)
I do not think that there is anyother way than to query from v$tables/views.
yes, from pfile/spfile or from v$parameter you can get compatibility of
database version, but exact version you can get only from v$tables/views
another option could be to show from OEM,which again internally uses the same
objects..
thanks!
Subodh
----- Original Message ----
From: Bill Ferguson <wbfergus@xxxxxxxxx>
To: ecandrietta@xxxxxxxxx
Cc: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, 24 September, 2009 18:47:13
Subject: Re: How can I identify the database
Re-reading the original question, I'm thinking that maybe you need a
script of some sort, with limited privileges, to run on (or query)
multiple databases, to determine what kind they are?
If so, and Gints suggestion of querying v$version doesn't work (which
it should), I think the only other way would be to query some of the
data dictionary tables to determine the max database size (which may
not always be accurate). As I recollect, the Express version has a max
database size of 4GB, so "most" databases under 4GB would probably be
a likely candidate for the Express version, while those above 4GB
obviously wouldn't be.
--
-- Bill Ferguson
On Thu, Sep 24, 2009 at 5:41 AM, Eriovaldo Andrietta
<ecandrietta@xxxxxxxxx> wrote:
> 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$.
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
