willis7/invalid.sql

Created August 23, 2013 12:22

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/willis7/6318741.js"></script>
Save willis7/6318741 to your computer and use it in GitHub Desktop.

Download ZIP

Find all invalid objects in Oracle DB

Raw

invalid.sql

	select object_name from user_objects
	where status = 'INVALID'
	/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment