5.15 Converting Between Runtime and Full Development Environments
Learn about converting between runtime and full development environments.
This section describes how to convert between runtime and full development environments.
- About Runtime and Full Development Environments
An Oracle Application Express runtime environment enables users to run a production application without supporting the ability to change or edit the application. - Converting a Runtime Environment to a Full Development Environment
Start SQL*Plus and connect to the database where Oracle Application Express is installed asSYS
specifying theSYSDBA
role and run theapxdvins.sql
. - Converting a Full Development Environment to a Runtime Environment
Start SQL*Plus and connect to the database where Oracle Application Express is installed asSYS
specifying theSYSDBA
role and run theapxdevrm.sql
.
5.15.1 About Runtime and Full Development Environments
An Oracle Application Express runtime environment enables users to run a production application without supporting the ability to change or edit the application.
A runtime environment includes only the packages necessary to run your applications, making it a more hardened environment. It does not provide a web interface for administration.
You administer an Oracle Application Express runtime environment using SQL*Plus or SQL Developer and the APEX_INSTANCE_ADMIN
API.
See Also:
-
"Installing Exported Applications into a Runtime Environment" in Oracle Application Express Administration Guide
5.15.2 Converting a Runtime Environment to a Full Development Environment
Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS
specifying the SYSDBA
role and run the apxdvins.sql
.
To convert an Oracle Application Express runtime environment to a full development environment:
See Also:
-
SQL*Plus User's Guide and Reference for more information about SQL*Plus
5.15.3 Converting a Full Development Environment to a Runtime Environment
Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS
specifying the SYSDBA
role and run the apxdevrm.sql
.
Tip:
Before converting a full development environment to a runtime environment, export all Websheet applications. When you convert a development environment to runtime, existing Websheet data grids and reports will be deleted from all workspaces. Converting the environment back to a full development environment will not restore these Websheet data grids or reports.
To convert an Oracle Application Express full development environment to a runtime environment:
See Also:
SQL*Plus User's Guide and Reference for more information about SQL*Plus