SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to recompile invalid package bodies after data pump import

oraclemagicianOct 6 2006 — edited Oct 11 2006

Hi all,

I performed a full data pump import into an Oracle 10g (10.1.0.5) database running on Solaris 9
and the import ran fine. After I ran utlrp.sql script to recompile any invalid objects, I checked the dba_objects for invalid objects after the data pump import. I found 28 invalid objects of which the majority were package body objects that appear as invalid. The problem I have is that when I run the command
"ALTER PACKAGE package_name COMPILE BODY;" I receive error messages and the package body fails to recompile either as SYS or the schema owner. Any suggestions on how to get these packages to recompile?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2006

Added on Oct 6 2006

2 comments

809 views