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 188.8.131.52.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.
Objects sometimes go invalid if object they depend on where altered. Check dependancies with a script similar to http://home.adelphia.net/~marist89/s...how_depend.htm
I ran the scripts but there are no dependent objects. Could you please let me know how to trouble shoot this problem again ???
there is one sql which sounds like validate in oracle_home/rdbms directory or upgrade directory....
after upgradation, u can use this sql to validate any invalid objects.
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.