Re: How can I identify the database

  I don´t have any Oracle Express installed.   I can try tomorrow in the company some OE installation and check the result of global_db_name.

  Thanks a lot for now

[]s
Eriovaldo

On Thu, Sep 24, 2009 at 10:17 AM, Bill Ferguson <wbfergus_at_gmail.com> wrote:

> 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