Re: How can I identify the database
From: Bill Ferguson <wbfergus_at_gmail.com>
Date: Thu, 24 Sep 2009 07:17:13 -0600
Message-ID: <4025610e0909240617y28685781md2af574d908c76ee_at_mail.gmail.com>
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?
Date: Thu, 24 Sep 2009 07:17:13 -0600
Message-ID: <4025610e0909240617y28685781md2af574d908c76ee_at_mail.gmail.com>
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:Received on Thu Sep 24 2009 - 08:17:13 CDT
> 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