Learn how to convert between runtime and full development environments.
This section describes how to convert between runtime and full development environments.
SYS
specifying the SYSDBA
role and run the apxdvins.sql
.SYS
specifying the SYSDBA
role and run the apxdevrm.sql
.SYS
specifying the SYSDBA
role and run the apxdvins_con.sql
.SYS
specifying the SYSDBA
role and run the apxdevrm_con.sql
.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:
"About the Oracle Application Express Runtime Environment" in Oracle Application Express Administration Guide
"Installing Exported Applications into a Runtime Environment" in Oracle Application Express Administration Guide
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 in a non-CDB or locally in a PDB:
See Also:
"Creating or Updating Your Instance Administration Account."
"SQL*Plus User's Guide and Reference" for more information about SQL*Plus
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 in a non-CDB or locally in a PDB:
See Also:
SQL*Plus User's Guide and Reference for more information about SQL*Plus
Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS
specifying the SYSDBA
role and run the apxdvins_con.sql
.
To convert an Oracle Application Express runtime environment to a full development environment in a CDB:
See Also:
"Creating or Updating Your Instance Administration Account."
"SQL*Plus User's Guide and Reference" for more information about SQL*Plus
Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS
specifying the SYSDBA
role and run the apxdevrm_con.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 in a CDB:
See Also:
SQL*Plus User's Guide and Reference for more information about SQL*Plus