-
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
Jeff Hunter
-
alter function "NameFromLastDDL" compile
Yes This Worked ....Thanks a lot...
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
|