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 APEX runtime environment enables users to run an 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 APEX runtime environment using SQLcl or SQL Developer and the APEX_INSTANCE_ADMIN API.

See Also:

About the APEX Runtime Environment
Installing Exported Applications into a Runtime Environment in Oracle APEX Administration Guide

Converting a Runtime Environment to a Full Development Environment

Start SQLcl and connect to the database where Oracle APEX is installed as SYS specifying the SYSDBA role and run the apxdvins.sql.

To convert an Oracle APEX runtime environment to a full development environment:

Change your working directory to the apex directory where you unzipped the installation software.

Start SQLcl and connect to the database where Oracle APEX is installed as SYS specifying the SYSDBA role. For example:

On Windows:

<SYSTEM_DRIVE>:\ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: <SYS_password>

On UNIX and Linux:

$ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: <SYS_password>

Run apxdvins.sql. For example:
```
@apxdvins.sql
```
Follow the instructions in Creating or Updating Your Instance Administration Account.

See Also: Working with SQLcl in Oracle SQLcl User’s Guide

Converting a Full Development Environment to a Runtime Environment

Start SQLcl and connect to the database where Oracle APEX is installed as SYS specifying the SYSDBA role and run the apxdevrm.sql.

Note: To ensure the security and performance of your development environment, this functionality is not available in APEX instances running in Oracle Cloud.

To convert an APEX full development environment to a runtime environment:

Change your working directory to the apex directory where you unzipped the installation software.

Start SQLcl and connect to the database where APEX is installed as SYS specifying the SYSDBA role. For example:

On Windows:

<SYSTEM_DRIVE>:\ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: <SYS_password>

On UNIX and Linux:

$ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: <SYS_password>

Run apxdevrm.sql. For example:
```
@apxdevrm.sql
```

See Also: Working with SQLcl in Oracle SQLcl User’s Guide