Wednesday, May 29, 2013

HTMLDB_SYSTEM Package is Invalid After Removing APEX

Oracle Application Express (formerly HTML DB) - Version: 3.1.0.00.32 to 3.2.1.00.10 - Release: APEX 3.1 to 
Information in this document applies to any platform.

Symptoms
After removing APEX (Application Express) from the database using the apxremov.sql script, the object SYS.HTMLDB_SYSTEM is shown as invalid. 

Changes
Removed APEX from the database using apxremov.sql script. 

Cause
The apexremov.sql script removes APEX, but leaves the HTMLDB_SYSTEM package and synonym. 

Solution
As there is no fix to this issue in terms of a patch, remove the object manually by following the following steps:

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:46:04 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> drop package htmldb_system;

Package dropped.

SQL> drop public synonym htmldb_system;

Synonym dropped.

SQL> exit