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

Topics:

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

5.15.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 apxdvins.sql.

To convert an Oracle Application Express runtime environment to a full development SQL*Plus or SQL Developer and the APEX_INSTANCE_ADMIN API:

  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.

See Also:

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

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

See Also:

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