Instance administrators manage the Oracle Application Express runtime environment using SQL*Plus and the
About the Advantages of Using Runtime Environment
An Oracle Application Express runtime environment enables you to run production applications, but does not provide a web interface for administration or direct development of these applications.
Oracle recommends that you run any sensitive production Oracle Application Express applications with a runtime installation of Oracle Application Express. A runtime installation does not expose the web-based application development environment, thus preventing the use of App Builder, SQL Workshop, and related utilities on a production installation. Additionally, a runtime environment only includes the Oracle Application Express database objects and privileges necessary to run applications, making it a more hardened environment.
Websheets are not supported in an Oracle Application Express runtime environment.
"APEX_INSTANCE_ADMIN" in Oracle Application Express API Reference.
Installing an Exported Application in to a Runtime Environment
You administer the Oracle Application Express runtime environment using SQL*Plus and the
To install an exported application into a runtime installation, you must:
- Export the workspace from the Oracle Application Express instance where the application was developed as described in "Exporting and Importing a Workspace."
- Use SQL*Plus to import your workspace in to the runtime environment:
SYSTEM, or any schema to which the role
APEX_ADMINISTRATOR_ROLEhas been granted.
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
- Export and then import your application using SQL*Plus in to the runtime environment.
"Exporting an Application and Application Components" in Oracle Application Express App Builder User’s Guide