Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Tuesday, July 10, 2012

view / show Compilation error messages

What if you too many invalid objects how do get the errors messages for these objects




 
run the query against dba_errors and the text column holds the error message.






run the utlrp.sql to compile all the objects


SQL> @?/rdbms/admin/utlrp.sql

see it made any difference  if not then view the error messages from above and start troubleshooting..

No comments: