Oracle Application Express
|Return to Oracle APEX Home|
| Oracle Database XE and Application Express 3.1
|Oracle Database 10g Express Edition (Oracle Database XE) includes Oracle Application Express (Oracle APEX) release 2.1. With the release of Oracle Application Express 3.1, you can now upgrade the Application Express within your Oracle Database XE. This will enhance your development experience by providing you with all the new features introduced in
Oracle APEX 2.2,
Oracle APEX 3.0 and
Oracle APEX 3.1. Some of the most compelling improvements include PDF Printing, Flash Charts, Interactive Reports region, New Item Types, Improved Web Services support, Page and Region Caching, Supporting Objects (and the ability to import and install our latest
Packaged Applications), Item Finder, new themes, and dictionary views of the Oracle APEX metadata.
Database Management Differences between Oracle APEX 2.1 and 3.1
The following is a list of database management functions that cannot be performed using Oracle APEX 3.1 but that were features of Oracle APEX 2.1, the default interface of Oracle Database XE. For each, there is a SQL Statement provided that can be executed either in a SQL Worksheet of Oracle SQL Developer or using SQL*Plus when connected to your Oracle Database XE. Most of these commands need to be executed as the user SYS.
The Home page will appear different. There is no icon for Administration. As noted above, most database administration functions are not part of Application Express. Two exceptions are the Database Monitor and About Database. In Oracle Database XE, these are under the Administration menu. Within Oracle APEX 3.1, they are under Utilities. There are no icons for the Object Browser and SQL, those functions are part of the SQL Workshop. Other Administration functions are grouped on the far right in a task region and these pertain mostly to the administration of the workspace, not the database.
How to Upgrade
@apexins SYSAUX SYSAUX TEMP /i/
Then to change the password for the admin account run apxchpwd.sql and when prompted enter a password for the ADMIN account.
@apxchpwdOnce you complete the standard install, you need to perform the following steps to complete the upgrade:
When logging into Application Express 3.1 in Oracle Database XE, you will now be presented with a login page that prompts for Workspace, Username and Password. The Workspace name is equal to the database username used to login to Oracle Database XE. For example, in Oracle Database XE, if you used credentials Username=SCOTT, Password=TIGER, in Application Express 3.1, you will now use Workspace=SCOTT, Username=SCOTT, Password=TIGER.
For more information about Oracle Database XE, visit the Oracle Database 10g Express Edition OTN site. Please note that this Application Express upgrade does not change the support policy of Oracle Support. Oracle Database XE is supported only via the OTN forums. Oracle Support will not answer questions about any Oracle APEX 3.1 on XE issues, installation or otherwise.