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@xxxxxxxxxxxxx Date: 07/21/04 19:22:22 To: oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------