B.13 Converting Between Runtime and Full Development Environments
Learn how to convert 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 in a non-CDB or locally in a PDB
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 in a non-CDB or locally in a PDB
Start SQL*Plus and connect to the database where Oracle Application Express is installed asSYS
specifying theSYSDBA
role and run theapxdevrm.sql
. - Converting a Runtime Environment to a Full Development Environment in a CDB
Start SQL*Plus and connect to the database where Oracle Application Express is installed asSYS
specifying theSYSDBA
role and run theapxdvins_con.sql
. - Converting a Full Development Environment to a Runtime Environment in a CDB
Start SQL*Plus and connect to the database where Oracle Application Express is installed asSYS
specifying theSYSDBA
role and run theapxdevrm_con.sql
.
B.13.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:
-
"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
B.13.2 Converting a Runtime Environment to a Full Development Environment in a non-CDB or locally in a PDB
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
B.13.3 Converting a Full Development Environment to a Runtime Environment in a non-CDB or locally in a PDB
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
B.13.4 Converting a Runtime Environment to a Full Development Environment in a CDB
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
B.13.5 Converting a Full Development Environment to a Runtime Environment in a CDB
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