Difference between Oracle 10g Express Edition & Other editions

[Jignesh Gohel]

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??

[Masoud Kalali]

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.

[stu derby]

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