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