http://oracle-help.com/scripts/find-corrupted-objects-oracle-using-sql-query/
Find corrupted objects in Oracle using sql query