Setting up a Runtime Environment

When APEX is first installed, we can choose whether to install the APEX Full Development Environment or the APEX Runtime Environment. This can be changed at a later stage by running the SQL scripts provided with the APEX install. We can convert from an APEX Full Development Environment to an APEX Runtime Environment by running the SQL script apxdevrm.sql using the SYS user with the SYSDBA role. We can also convert a runtime environment back to a full development environment by running the SQL script apxdvins.sql. Converting the environment will leave our applications unchanged, and they can be run using the exact same URL. Now that we have seen how to convert to a Runtime environment, let's look at how we can manage the environment.

Note

The Oracle SYS user is a special user that is automatically created when the Oracle Database is first installed. It contains all base tables and views for the data dictionary, and is critical for running the database. Never...