I was moving tables and rebuilding indexes to try to reduce my number of
extents and try to improve performances. I do not know if this caused it
or
not, but I have a bunch of SYS & SYSTEM owned objects that are marked
INVALID. When I try to recompile them (I tried 2 different ones), they
have
a bunch of errors indicating variables need to be defined. Is there a
way I
can reload and rebuild the objects without interfering with the
database?
The objects are:
OWNER SUBSTR(OBJECT_NAME,1,37)
---------- -------------------- --------------------------
SYS DBMS_REPCAT_RGT
SYS UTL_INADDR
SYS UTL_SMTP
SYS UTL_SMTP
SYS UTL_TCP
SYSTEM DBMS_ALERT
SYSTEM DBMS_DESCRIBE
SYSTEM DBMS_EXPORT_EXTENSION
SYSTEM DBMS_IJOB
SYSTEM DBMS_IREFRESH
SYSTEM DBMS_ISNAPSHOT
SYSTEM DBMS_JOB
SYSTEM DBMS_REFRESH
SYSTEM DBMS_SNAPSHOT
SYSTEM DBMS_SQL
SYSTEM DBMS_TRANSACTION
SYSTEM DBMS_UTILITY
SYSTEM DEF$_TRAN
SYSTEM DEFCALL
SYSTEM DEFCALLDEST
SYSTEM DEFERRCOUNT
SYSTEM DEFERROR
Received on Thu Apr 15 2004 - 10:05:45 CDT
