Re: How to find out which version is installed - standard or enterprise?

From: Tanel Poder <tanel_at_@peldik.com>
Date: Tue, 5 Aug 2003 16:26:30 +0300
Message-ID: <3f2fb089$1_1@news.estpak.ee>

Hi!

Your's is standard. My EE says that:

SQL> select banner from v$version;

BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production

SQL> Tanel.

"Andreas Driesen" <andreas.driesen_at_tesla.de> wrote in message news:bgo73s$elt$06$1_at_news.t-online.com...
> Hello
>
> on Windows 2000 server with Oracle 9.2 following appears:
>
> Oracle9i Release 9.2.0.1.0 - Production
> PL/SQL Release 9.2.0.1.0 - Production
> CORE 9.2.0.1.0 Production
> TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
> NLSRTL Version 9.2.0.1.0 - Production
>
> Is it Enterprise or Standard now? ;-)
>
> Greetings,
> Andreas
>
>
> "Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> schrieb im Newsbeitrag
> news:E2F6A70FE45242488C865C3BC1245DA703FE0C80_at_lnewton.leeds.lfs.co.uk...
> > SQL> select Banner from v$version
> >
> > BANNER
> > ----------------------------------------------------------------
> > Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
> > PL/SQL Release 9.2.0.1.0 - Production
> > CORE 9.2.0.1.0 Production
> >
> > TNS for HPUX: Version 9.2.0.1.0 - Production
> > NLSRTL Version 9.2.0.1.0 - Production
> > 5 rows selected
> >
> > The first one gives the game away :o)
> >
> > Cheers,
> > Norman.
> >
> > PS. This is on HPUX on a 64 bit HP server.
> >
>
>
Received on Tue Aug 05 2003 - 08:26:30 CDT