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 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 APEX is installed as SYS specifying the SYSDBA role and run the apxdvins.sql.
• Converting a Full Development Environment to a Runtime Environment
  Start SQL*Plus 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 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 APEX runtime environment using SQL*Plus or SQL Developer and the APEX_INSTANCE_ADMIN API.

See Also:

• About the Oracle 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 SQL*Plus 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 SQL*Plus and connect to the database where Oracle APEX is installed as SYS specifying the SYSDBA role. For example:

   • On Windows:

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

   • On UNIX and Linux:

     $ sqlplus /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:

SQL*Plus User's Guide and Reference for more information about SQL*Plus

6.14.3 Converting a Full Development Environment to a Runtime Environment

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

To convert an Oracle 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 SQL*Plus and connect to the database where Oracle APEX is installed as SYS specifying the SYSDBA role. For example:

   • On Windows:

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

   • On UNIX and Linux:

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

3. Run apxdevrm.sql. For example:

   @apxdevrm.sql
   

See Also:

SQL*Plus User's Guide and Reference for more information about SQL*Plus