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

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

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : June-2018

**********************************************************************************


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]


I am certified Oracle Cloud Architect:
Oracle Cloud Infrastructure 2018 Certified Architect Associate
Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate

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: