Wednesday, May 29, 2013

How to remove Application Express 3.0 and above

oracle@solaris11:/u01/app/oracle/product/11.2.0/dbhome_2$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed May 29 22:29:57 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

SQL> show user
USER is "SYS"

SQL> select version,status from dba_registry where comp_id='APEX';

VERSION                        STATUS
------------------------------ -----------
3.2.1.00.12                    VALID

SQL> @?/apex/apxremov.sql
...Removing Application Express
old   1: alter session set current_schema = &APPUN
new   1: alter session set current_schema = APEX_030200

Session altered.


PL/SQL procedure successfully completed.


no rows selected

old   2:     if '&UPGRADE' = '1' then
new   2:     if '1' = '1' then

PL/SQL procedure successfully completed.


Session altered.


PL/SQL procedure successfully completed.

old   1: drop user &APPUN cascade
new   1: drop user APEX_030200 cascade

User dropped.

old   2:     if '&UPGRADE' = '1' then
new   2:     if '1' = '1' then

PL/SQL procedure successfully completed.

old   5:     if '&UPGRADE' = '1' then
new   5:     if '1' = '1' then

PL/SQL procedure successfully completed.

old   2:     if '&UPGRADE' = '1' then
new   2:     if '1' = '1' then

PL/SQL procedure successfully completed.

...Application Express Removed


SQL> select version,status from dba_registry where comp_id='APEX';

no rows selected