RE: Invalid Package under SYS

  • From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 26 Apr 2004 14:53:29 -0700

Are these invalid packages some that you intend on using? If you never =
need to use them, you could ignore the fact that they are invalid.

You can look in dba_errors to try to guess why the package is invalid. =
And you can always say "alter package ... compile body ;" to compile =
each package individually.

> -----Original Message-----
> Hamid Alavi
> I have run the utlirp under the sys account BUT Still I can see some
> packages are invalid.
> Any Idea or solution?=20
Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: