Could someone tell me why the objects in the database were invalid, it happened three or four times already, I checked with the users and they didn't run anything special which could cause the objects in the database invalid.
I am running 220.127.116.11.5 on Windows 2000, I upgraded this database from 8.1.6 month ago.
What could cause the objects in the database invalid. and how to trouble shoot this problem.
I'm not suprised there are no dependant objects. The objects that were invalidated DEPEND on another object. Check dba_objects.created and dba_objects.last_ddl for objects where created/altered/compiled in the last few days. Then get the dependancies for THOSE objects. Odds are the objects that are invalidated will be a dependant of the objects that were modified.