When opening the schema browser >> select the procs tab >> Hit compile all invalid objects, the following error appears:
DBMS_UTILITY.COMPILE_SCHEMA fails
ORA-20001: Cannot recompile SYS objects
ORA-06512: at %sline %s
DBMS_UTILITY.COMPILE_SCHEMA cannot be used to recompile objects in the SYS schema.
Upon running a 'Compile all Invalid Objects', Toad runs
begin DBMS_UTILITY.COMPILE_SCHEMA( SCHEMA Name, FALSE ); end;
According to Oracle's Metalink at <http://metalink.oracle.com/>, there have been problems with the DBMS_UTILITY package.
The ORACLE BUG number is BUG:1685488 <http://metalink.oracle.com/metalink/plsql/showdoc?db=BUG&id=1685488>.
According to Oracle, the DBA must perform the following steps to resolve this issue. (Please contact Oracle for more information regarding this bug.)
PL/SQL Generic Note Using DBMS_UTILITY.COMPILE_SCHEMA For SYS Objects Fails With ORA-20001 ORA-06512 225942.1
21-JAN-2003
fact: Oracle Server - Enterprise Edition 9
fact: Oracle Server - Enterprise Edition 8
fact: PL/SQL
fact: DBMS_UTILITY
symptom: Recompile invalid SYS objects fails
symptom: DBMS_UTILITY.COMPILE_SCHEMA fails
symptom: ORA-20001: Cannot recompile SYS objects
symptom: ORA-06512: at %sline %s
cause: DBMS_UTILITY.COMPILE_SCHEMA cannot be used to recompile objects in
the SYS schema.
WORKAROUND:
To recompile invalid objects, use utlrp.sql instead.
Only INTERNAL or SYS can run this script.
on Unix:
$sqlplus "/ as sysdba" @$ORACLE_HOME/rdbms/admin/utlrp.sql
on Windows:
C:\>sqlplus "/ as sysdba" @%ORACLE_HOME%\rdbms\admin\utlrp.sql
