Databases Reference
In-Depth Information
Note
Some versions of the Oracle database include an earlier version of APEX built in. In any case, the
following steps will still apply whether you are installing APEX from scratch or upgrading to a newer version of
APEX
2.
Download the software. The latest version of Oracle APEX (as of the date of
writing this topic) is version 4.0.2. You can download the latest version of APEX
from the following URL:
tools/
apex/downloads/index.html
3.
Unzip the contents of the downloaded APEX package into a folder named
APEXFILES\APEX on your system (e.g.:
C:\APEXFILES\APEX
).
Note
C:\APEXFILES\APEX
will be your APEX home directory. It is important that your subfolder is named
APEX.
4.
Logon to SQL*Plus on your system as the SYSDBA.
5.
You will need to create two tablespaces. Run the statements shown in Listing
1-1 in SQL*Plus.
Listing 1-1.
Creating the APEX Tablespaces
CREATE TABLESPACE APEX datafile 'C:\oraclexe\oradata\XE\APEX.dbf'
SIZE 500M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE APEX_FILES datafile 'C:\oraclexe\oradata\XE\APEX_FILES.dbf'
SIZE 100M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
