Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: INVALID SYSTEM OBJECTS

Re: INVALID SYSTEM OBJECTS

From: Alex Ivascu <alexdivascu_at_hotmail.com>
Date: Thu, 15 Apr 2004 08:08:34 -0700
Message-ID: <ozxfc.7863$ab3.1714@fed1read02>


Rerun catalog and catproc scripts.

Alex Ivascu

"P. Smith" <papalphaus_at_yahoo.com> wrote in message news:9aec9150.0404150705.5fde418f_at_posting.google.com...
> 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:08:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US