Wednesday, May 29, 2013

HTMLDB_SYSTEM Package is Invalid After Removing APEX

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

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

Removed APEX from the database using apxremov.sql script. 

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

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 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 - 64bit Production

SQL> drop package htmldb_system;

Package dropped.

SQL> drop public synonym htmldb_system;

Synonym dropped.

SQL> exit

No comments:

Post a Comment