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

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

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

  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 Application Express 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.

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

  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 Application Express 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

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

  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 Application Express 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_con.sql. For example:
    @apxdvins_con.sql
    
  4. Follow the instructions in Creating or Updating Your Instance Administration Account.

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

  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 Application Express 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_con.sql. For example:
    @apxdevrm_con.sql
    

See Also:

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