Home » RDBMS Server » Server Administration » Enterprise Vs standard edition
Enterprise Vs standard edition [message #55248] Mon, 13 January 2003 12:51 Go to next message
sai
Messages: 27
Registered: October 2001
Junior Member
What is the difference between Oracle Enterprise edition and standard edition?How will I find out that
which edition am I currently running?

Thanks in advance

Sai
Re: Enterprise Vs standard edition [message #55251 is a reply to message #55248] Mon, 13 January 2003 13:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
when you login to sql plus or svrmgrl, EE or SE will be displayed.
SQL*Plus: Release 8.1.6.0.0 - Production on Mon Jan 13 15:02:12 2003

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Connected to:
[b]
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production[/b]
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
[b]
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production [/b]
PL/SQL Release 8.1.6.0.0 - Production
CORE    8.1.6.0.0       Production
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

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

with SE many tools and functionalities are not available like Advanced Security, change management
pack, diagnostic pack, partitioning, oracle parallel 
server, advanced replication etc.
BUT  THE BASE FUNCTIONALITY FOR A RDBMS EXISTS WITH SE.

Re: Enterprise Vs standard edition [message #55253 is a reply to message #55248] Mon, 13 January 2003 14:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
yes.
But why would one "move" to standard edition?
id doesnt have many features.
and wat do u mean by "Move"?
move data?
SE is different from EE.
i mean SEPERATE CD's.
Re: Enterprise Vs standard edition [message #55274 is a reply to message #55248] Wed, 15 January 2003 07:03 Go to previous message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
The licensing cost is different. Of coarse more for EE than SE. And then accordingly you get less features.
Previous Topic: uninstall 8.0
Next Topic: Default Users in 9i ? Urgent
Goto Forum:
  


Current Time: Fri Sep 20 03:40:57 CDT 2024