I'm not suggesting this will fix it. I'm saying *you* need to attempt a compilation of each individual item to allow *you* to identify the specific compilation errors that prevented that item from compiling. Once you know that, *you* can make a decision about what is needed to allow that item to be compiled.
For example, if the package body scott.my_package fails to compile, I can do this,
- Code: Select all
alter package scott.my_package compile body;
In attempting to compile the object (and failing) I can use show errors to list the specific reasons why it fails. I can then take the appropriate action to allow the object to compile.
In many cases, the failures are due to missing system or object privileges, in which case you must grant them to allow the object to compile.
Just to confirm, this is not the solution to the failed compilations, it is the process *you* must follow to investigate and subsequently correct the issues.