Apex is a great tool for rapid web applications based on Oracle Database. It’s free, and if you’re happy with Oracle XE’s limitations, then it’s perfect, you have the database free as well. I’ve been following APEX for long time ago, since it was called HTML DB, and wrote 2+ years ago a guide how to install APEX on XE.
Now APEX 4.0.1 is GA and most of the people would like to upgrade. It’s very simple.

1. Download APEX from OTN
Read the rest of this entry »
Tags:
10g,
apex,
application express,
Database,
download,
express edition,
installation,
oracle,
XE
12 Comments »
well… my colleagues from SQL Dev team will probably take out from the marketplace our competition. Having so many features for free is something that me and all the users are highly appreciating.

SQL Developer 2.1 EA1
Some facts of SQL Developer 2.1 Early Adopter 1: Read the rest of this entry »
Tags:
Database,
migration,
oracle,
sql developer,
XE
2 Comments »
Best way to have a easy to access XE database and APEX on top of it is to put them on a Ubuntu Server virtual machine that I start just when I need.
Installation of 10g Express Edition should not take more than 10 minutes and the steps are below:
1. Prepare the swap space
If you have less than 1GB memory run the following commands to create swap space:
$ sudo dd if=/dev/zero of=/swpfs1 bs=1M count=1000
$ sudo mkswap /swpfs1
$ sudo swapon /swpfs1
Read the rest of this entry »
Tags:
10g,
download,
Jaunty Jackalope,
Linux,
oracle,
XE
20 Comments »
Lots of people landed on my blog by searching for “10g XE disadvantages”, but unfortunately I don’t have such an article. I mean until now 🙂
So what are the disadvantages of using 10g XE database? :
- it’s not supported by Oracle support
- it is working on just one processor core, no matter how many you have
- it will not use more than 1 GB of RAM, no matter how much RAM you have
- you cannot store more than 4 GB of user data, hard-coded limitation
- you’ll not find patches for it
- not yet a 11g version
Of course there are lots of advantages:
Read the rest of this entry »
Tags:
10g,
Database,
oracle,
XE
6 Comments »

I’ve been asked many times if there is possible to install Oracle Application Express on Express Edition of 10g database, both of them being free products. The answer is YES, and the procedure is quite simple, as very well indicated on Oracle website
The steps would be: Read the rest of this entry »
Tags:
10g,
apex,
application express,
Database,
download,
express edition,
installation,
oracle,
XE
2 Comments »