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 18.104.22.168.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 ran the scripts but there are no dependent objects. Could you please let me know how to trouble shoot this problem again ???
01-29-2002, 10:55 AM
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.
01-29-2002, 11:00 AM
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.