Managing a 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. To learn more, see "APEX_INSTANCE_ADMIN" in Oracle Application Express Application Builder User's Guide.

In order 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 FLOWS_030100, SYS, SYSTEM, or any schema to which the role APEX_ADMINISTRATOR_ROLE has been granted.

   • Run the workspace import file.

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

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.