6.14 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.
• 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.
• 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.

6.14.1 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

6.14.2 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:

1. Change your working directory to the apex directory where you unzipped the installation software.
2. 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

3. Run apxdvins.sql. For example:

   @apxdvins.sql
   

4. Follow the instructions in Creating or Updating Your Instance Administration Account.

See Also:

Working with SQLcl in Oracle SQLcl User’s Guide

6.14.3 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:

1. Change your working directory to the apex directory where you unzipped the installation software.
2. 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

3. Run apxdevrm.sql. For example:

   @apxdevrm.sql
   

See Also:

Working with SQLcl in Oracle SQLcl User’s Guide