1. Installation Guide
  2. Installing Application Express and Configuring Embedded PL/SQL Gateway
  3. Converting Between Runtime and Full Development Environments

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

Parent topic: Installing Application Express and Configuring Embedded PL/SQL Gateway

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

Parent topic: Converting Between Runtime and Full Development Environments

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

Parent topic: Converting Between Runtime and Full Development Environments

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

Parent topic: Converting Between Runtime and Full Development Environments

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

See Also:

Parent topic: Converting Between Runtime and Full Development Environments

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

Parent topic: Converting Between Runtime and Full Development Environments