RE: How can I identify the database

From: Channa, Santhosh <Santhosh.Channa_at_McKesson.com>
Date: Thu, 24 Sep 2009 10:11:26 -0400
Message-ID: <A1DEC407B8BBA84CA6CA498AA39CF54803A5545B_at_NDHV3001.na.corp.mckesson.com>



Did you try grepping the lines from sqlplus command just before the SQL> prompt?

Regards,
Santhosh Channa

P Consider the environment. Please don't print this e-mail unless you really need to.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Subodh Deshpande Sent: Thursday, September 24, 2009 9:44 AM To: ecandrietta_at_gmail.com
Cc: ORACLE-L
Subject: Re: How can I identify the database

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_at_gmail.com> To: ecandrietta_at_gmail.com
Cc: ORACLE-L <oracle-l_at_freelists.org> 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_at_gmail.com> 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$.
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 24 2009 - 09:11:26 CDT

Original text of this message