aspose file tools*
The moose likes JDBC and the fly likes Difference between Oracle 10g Express Edition & Other editions Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Difference between Oracle 10g Express Edition & Other editions" Watch "Difference between Oracle 10g Express Edition & Other editions" New topic
Author

Difference between Oracle 10g Express Edition & Other editions

Jignesh Gohel
Ranch Hand

Joined: Dec 28, 2004
Posts: 276
Hi,

As mentioned in the subject i would like to know the difference between Oracle 10g XE & Other standard editions.

And if i want to migrate from Oracle 8i to Oracle 10g which edition should i install??


Regards,
Jignesh

The Art Of Life Is To Know When To Be Useless And When To Be Useful - CHUANG TZU
Masoud Kalali
Author
Ranch Hand

Joined: Jul 08, 2004
Posts: 531

oracle 10g EX if i am not mistaken ,
just will use 1gig of RAM.
just will utilize one CPU.
just will allows you to have a DB of 4GIG size.

these are basic restriction over Oracle 10g EX ,
It does not have full blown Enterprise Manager , it does not support clustring .....


for more information take a look at :
www.oracle.com/technology/products/database/xe/pdf/dbxe_faq.pdf
http://www.oracle.com/technology/products/database/oracle10g/pdf/twp_general_10gdb_product_family.pdf


take a look at your budget and the link above then decide about edition you need.


Masoud Kalali
Software Engineer - My Weblog - GlassFish Security
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
There's 3 big differences with the Express Edition over the Standard , price (it's free), you may redistribute it, and it has built-in limits.

As Oracle says:
Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 4GB of user data, use up to 1GB of memory, and use one CPU on the host machine.

http://www.oracle.com/technology/products/database/xe/index.html
 
 
subject: Difference between Oracle 10g Express Edition & Other editions