C.4.2 Removing Oracle Application Express from the Database

Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role and execute the SQL> @apxremov.sql command.

This section describes how to remove the Oracle Application Express schema, synonyms, and users from the database without deleting the database.

Note:

Do NOT follow these steps if you have upgraded your database from a prior release, and still want to use the prior release of Oracle Application Express. For information about reverting to a prior release, see Reverting to a Previous Release. If you are not sure whether you have completed a new installation or an upgrade installation, review Cleaning Up After a Failed Installation to verify if a previous release of Oracle Application Express exists in the database.

To remove Oracle Application Express from the database:

1. Change your working directory to the apex directory where you unzipped the Oracle Application Express software.
2. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role:

   • On Windows:

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

   • On UNIX and Linux:

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

3. Execute the following command:

   SQL> @apxremov.sql
   

4. After successfully removing Application Express using apxremov.sql, you must exit your current SQL*Plus session and reconnect before attempting another install using apexins.sql.