Finally, while I was on vacation, on 2nd Sptembre 2011, Oracle Database Express Edition 11g Release 2, AKA "Oracle XE", is become a full release for 11g version.
For those who haven't met Oracle XE before, it is the only free edition of Oracle and best way to find what Oracle database is in a way of Microsoft instillation and maintenance.
Beside many other restrictions, this version allows for up to 11Gb of data (4Gb was in previous version-10gR2) and will use only 1 CPU and 1 GB of RAM (server can have more power, but it won't get used by the database).
It comes with Apex 4.0 pre-installed.
You don't get some of the snazzy Enterprise Edition features. No FLASHBACK DATABASE or FLASHBACK TABLE. No PL/SQL Function Result Cache. No Diagnostic or Tuning packs. Or table compression ... etc. .
Remember, you can always upgrade your database to Standard or Enterprise Edition if you outgrow the resource constraints of Express Edition.
Cheers!
as it happens I do my dev work on XE and then expdp my schema and give that to the DBA for schema creation. Its quite handy and allows developers to work on localhost with fewer hiccups when migrating.
ReplyDeleteI love it
Yap!
ReplyDeleteBut be careful to place right COMPATIBLE parameter in expdp action.
:-)