You can install different versions of Oracle Application Express into different PDBs.
Once you have removed Application Express from the container database, then you can install a local Application Express within each PDB as required. When Application Express is installed locally there are no Application Express metadata linked objects and all packages, views, and tables are created within the APEX_050100
schema, within each PDB where Application Express is installed.
Topics:
Learn how to uninstall Application Express from a CDB.
To uninstall Application Express from a CDB:
Note:
This section describes removing Application Express 5.1 from a CDB. If you wish to remove Oracle Application Express from the CDB that shipped with Oracle Database 12.1, you should use apxremov_con.sql
from either $ORACLE_HOME/apex
, or from a 4.2.6 APEX distribution.
Learn how to install Application Express locally in a PDB.
Once you have removed Application Express from the container database by following the instructions in "Uninstalling Application Express 5.1 from a CDB," you can install Application Express locally in a PDB.
To install Application Express locally in a PDB:
Note:
Oracle Database SQL Language Reference for more information about SQL*Plus
When Application Express installs, it creates three new database accounts:
APEX_050100
- The account that owns the Application Express schema and metadata.
FLOWS_FILES
- The account that owns the Application Express uploaded files.
APEX_PUBLIC_USER
- The minimally privileged account is used for Application Express configuration with Oracle REST Data Services or Oracle HTTP Server and mod_plsql
.
If you configured RESTful Web services, then these additional accounts are created:
APEX_REST_PUBLIC_USER
- The account used when invoking RESTful Services definitions stored in Application Express.
APEX_LISTENER
- The account used to query RESTful Services definitions stored in Application Express.
Learn how to reinstall Application Express into a CDB.
If you previously uninstalled Oracle Application Express release 4.2 and want to reinstall Application Express into a CDB you need to install Oracle Application Express release 4.2.4 using the Oracle Database 12c distribution. Following the reinstallation you can apply Application Express patches if required as outlined in Patching or Upgrading Application Express in the CDB.
To reinstall Application Express into a CDB:
When Application Express installs, it creates three new database accounts:
APEX_050100
- The account that owns the Application Express schema and metadata.
FLOWS_FILES
- The account that owns the Application Express uploaded files.
APEX_PUBLIC_USER
- The minimally privileged account is used for Application Express configuration with Oracle REST Data Services or Oracle HTTP Server and mod_plsql
.
If you configured RESTful Web services, then these additional accounts are created:
APEX_REST_PUBLIC_USER
- The account used when invoking RESTful Services definitions stored in Application Express.
APEX_LISTENER
- The account used to query RESTful Services definitions stored in Application Express.
See Also: