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
No comments:
Post a Comment