-
Hi,
I applied the patchset 8.1.7.2 on 8.1.7.0 in solaris anf after that i recompiled some of the invalid objects.But i was unable to recompile a function NameFromLastDDL of sys schema.
When i tried to recompile this function,it is giving me a error ORA-04043 object does not exist.When i tried to drop this function ,then also the same error message.
I queried the dba_objects and found the name of the object as typed above not all the charachers in upper case was found as invalid.What to do now?.
Pls. help me
Thanks
-
alter function "NameFromLastDDL" compile
or, you can use the utlrp.sql script from $OH/rdbms/admin
-
alter function "NameFromLastDDL" compile
Yes This Worked ....Thanks a lot...