Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> newbie q: compiling a package
We have a system which monitors oracle for invalid packages. One came
up with the following one.
sapsnd:orasnd 27> ./orastat -iv
2002/10/15-16:06:07 orastat | oraver=8.1.7 oraver3=8.1 sqlcmd=sp
2002/10/15-16:06:07 orastat | ORACLE_SID=SND
ORACLE_HOME=/oracle/SND/817_64
2002/10/15-16:06:07 orastat | Version=2.33 Host=sapsnd Company=ssmhc
2002/10/15-16:06:07 orastat | Invalid Objects
Object Name Object TypeStatus
SYSTEM.SPACER_ANALYZER PACKAGE BODY INVALID
2002/10/15-16:06:08 orastat | Found 1 Invalid Objects
I tried to recomplie it and got:
SVRMGR> alter PACKAGE SYSTEM.SPACER_ANALYZER compile BODY; MGR-00073: Warning: PACKAGE SYSTEM.SPACER_ANALYZER created with compilation errors.
And the package still reports that it INVALID.
So... many questrions.
What created this package? Is it something that came in the patch from
8.1.7.0 to 8.1.7.3? How can I look at it to recompile it with out
getting errors? How do you look at ANY package? What is a package?
Thanks for your patience...
Vince
Received on Tue Oct 15 2002 - 16:10:12 CDT