Enterprise Edition or Standard Edition
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Enterprise Edition or Standard Edition

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    Enterprise Edition or Standard Edition

    Hi Guys
    We used to have Oracle 8.1.7.0 Standard Edition. We just upgrade to 8.1.7.4.
    What script will show me the type of version we have, stating not only the "8.1.7.4 but Enterprise edition
    or Standard edition.

    I query v$version.
    select * from v$version;
    it did not give me the info I really want.
    Select * form v$license; not satisfy with the result.

    I need the query to return the word"Enterprise Edition or Standard Edition"
    Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Don't know what you really mean by v$version..
    This one works just fine here...
    Code:
    scott@NICK817.TARRY.LOCAL> select * from v$version
      2  /
    
    BANNER
    ----------------------------------------------------------------
    Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
    PL/SQL Release 8.1.7.4.0 - Production
    CORE    8.1.7.2.1       Production
    TNS for 32-bit Windows: Version 8.1.7.4.0 - Production
    NLSRTL Version 3.4.1.0.0 - Production
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    or maybe you can try this sql:

    • select decode(instr(banner, 'Enterprise'), 0, 'Standard Edition', 'Enterprise Edition') from v$version where banner like '%Oracle%'
      /
    -- Dilip

  4. #4
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    This is what my result show on the production.
    SQL> select * from v$version;

    BANNER
    --------------------
    Oracle8i Release 8.1.7.4.1 - Production
    PL/SQL Release 8.1.7.4.0 - Production
    CORE 8.1.7.2.1 Production
    TNS for 32-bit Windows: Version 8.1.7.4.0 - Production
    NLSRTL Version 3.4.1.0.0 - Production

    No mention of Enterprise or Standard.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  5. #5
    Join Date
    May 2002
    Posts
    2,645
    Why don't you simply start OUI and see what it says?

  6. #6
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Thanks Patel_Dil
    Your script is just what I wanted.
    Again Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Can you pl. run the following query and let me know of the output

    Code:
                SELECT * FROM product_component_version
                WHERE product LIKE '%Oracle%';

    -Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  8. #8
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by sambavan
    Can you pl. run the following query and let me know of the output

    Code:
                SELECT * FROM product_component_version
                WHERE product LIKE '%Oracle%';

    -Sam
    Sam,
    V$PRODUCT_COMPONENT_VERSION is derived from V$VERSION so it won't show anything different.
    Extract from catalog.sql
    Code:
    create or replace view product_component_version(product,version,status) as
    (select
    substr(banner,1, instr(banner,'Version')-1),
    substr(banner, instr(banner,'Version')+8,
    instr(banner,' - ')-(instr(banner,'Version')+8)),
    substr(banner,instr(banner,' - ')+3)
    from v$version
    where instr(banner,'Version') > 0
    and
    ((instr(banner,'Version') <   instr(banner,'Release')) or
    instr(banner,'Release') = 0))
    union
    (select
    substr(banner,1, instr(banner,'Release')-1),
    substr(banner, instr(banner,'Release')+8,
    instr(banner,' - ')-(instr(banner,'Release')+8)),
    substr(banner,instr(banner,' - ')+3)
    from v$version
    where instr(banner,'Release') > 0
    and
    instr(banner,'Release') <   instr(banner,' - '))
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width