title: How to fetch the list of errors for invalid objects in Oracle 10g
body: <p>Explanation: I have more than 200 invalid objects in my DB, the reasons could be couple of objects only (others due to dependancy). Is there a way we can select the object name and the 'Error Reason' for it being invalid. </p>