Re: Enterprise edition and Standard edition

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Thu, 22 Jul 2004 11:31:32 -0400
Message-Id: <40FFDDD4.000036.00336@CACHITOSS>

This table can be useful, because in some specific process you can first verify if the table has it or not, and based on the result took one or othe process.  

select * from v$option  

-------Original Message-------
 

From: oracle-l_at_freelists.org
Date: 07/21/04 19:22:22
To: oracle-l_at_freelists.org
Subject: Enterprise edition and Standard edition  

On all of our machines we have enterprise edition databases.  

Due to price constraint, for one of our applications, the business = bought standard edition.  

Question:  

After installing standard edition Oracle software and after creating the = database, how do I know that it is standard edition?  

Is there any command through which I can find out the edition?  

For enterprise edition, whenever I login through SQLPLUS, I see = enterprise edition meesage.  

Environment:  

OS - Solaris 5.8
Database : 9.2  

Thanks,  

Rao

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Jul 22 2004 - 10:34:56 CDT