Standard Edition vs Enterprise Edition ??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Standard Edition vs Enterprise Edition ??

  1. #1
    Join Date
    Jan 2001
    Posts
    30

    Question

    How can I determine if the Edition of Oracle 8.0.5 that is iinstalled is Standard or Enterprise?
    Thanks,

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Login thru Sql plus and check the the first few lines before the prompt. It might say it there.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    system@dev815nt.us> select * from v$version
    2 /

    BANNER
    ----------------------------------------------------------------
    Oracle8i Enterprise Edition Release 8.1.5.1.0 - Production
    PL/SQL Release 8.1.5.1.0 - Production
    CORE Version 8.1.5.0.0 - Production
    TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
    NLSRTL Version 3.4.0.0.0 - Production
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jan 2001
    Posts
    30
    Version 8.0.5 doesn't announce what edition it is in SQL*Plus.
    I also tried v$version and doesn't say either.

  5. #5
    Join Date
    Aug 2000
    Posts
    194
    I guess, if it doesn't say explicitly as "Enterprise Edition", its standard edition.

    If its an Enterprose Edition, you would see output similar to the one listed by Jeff, else without the "Enterprise Edition " on the first line.

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