1.select name, text from user_errors where type = 'JAVA CLASS&';
The output for the ORA-29521 should be in the form of ORA-29521: referenced name
';oracle/apps/
2.With the value of
$
The file is separated into sections for each jar file and the classes (names) it contains.
3.Once you find the name of the jar file where the class is contained ,Source the environmental
file that is present in
4.Go to the $
for ';loadjava'; is as follows:
loadjava -user apps/
5.Execute the same action plan and check whether invalids is getting reduced by executing the
following query
Select count(1),owner,object_type from dba_objects where status=';INVALID'; group by
object_type,owner;
No comments:
Post a Comment