2.8 Installing Exported Applications in a Runtime Environment


Functionality in the Administration Services application is not available in Oracle Database Cloud Service (Database Schema).

This section describes how to install exported applications into a runtime environment.

2.8.1 About the Advantages of Using Runtime Environment

An Oracle Application Express runtime environment enables you to run production applications, but it does not provide a web interface for administration. A runtime environment only includes the packages necessary to run your application, making it a more hardened environment.You administer the Oracle Application Express runtime environment using SQL*Plus and the APEX_INSTANCE_ADMIN API.

See Also:

"APEX_INSTANCE_ADMIN" in Oracle Application Express API Reference.


Websheets are not supported in an Oracle Application Express runtime environment.

2.8.2 Installing an Exported Application in to a Runtime Environment

To install an exported application into a runtime installation, you must:

  1. Export the workspace from the Application Express instance where the application was developed as described in "Exporting and Importing a Workspace."

  2. Use SQL*Plus to import your workspace in to the runtime environment:

    • Connect as APEX_050000, SYS, SYSTEM, or any schema to which the role APEX_ADMINISTRATOR_ROLE has been granted.


      The APEX_ADMINISTRATOR_ROLE must be granted directly to a user and not through another database role.
    • Run the workspace import file.

      If the workspace export file was created with a version of Oracle Application Express lower than 3.2, you must connect as APEX_050000.

  3. Export and then import your application using SQL*Plus in to the runtime environment. See "Exporting an Application and Related Files" in Oracle Application Express Application Builder User's Guide.