-
System Packages are invalid
Hi there, I ran a query against dba_objects and found 1 system package invalid. I ran alter package compile package. After that I found 2 packages in dba_objects that were invalid. I ran the same alter package against those and now I have over 100 packages showing up as invalid? What do I do????? Thanks in advance.
Thanks,
Afshin.
-
The following object types are now invalid:
OBJECT_TYPE COUNT(1)
------------------ ----------
PACKAGE 23
PACKAGE BODY 132
PROCEDURE 3
VIEW 1
Thanks,
Afshin.
-
@?/rdbms/admin/catproc
to see whether fix your problem.
-
I've found catproc will cause invalid's, try
@?/rdbms/admin/utlrp
to sort this.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
Did run @?/rdbms/admin/utlrp resolve it?
Check Note 113947.1 on metalink.oracle.com
-
Sorry for the delay in my response!
I did run the utlrp.sql command. First time, it fixed some of the objects, but 20 were still invalid. I ran it a second time and now 0 are invalid. Thank you everyone for your help!
Thanks,
Afshin.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|