invalid objects

[ashley75]

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 8.1.7.2.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.

Please advise

[marist89]

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

[ashley75]

jEFF,


I ran the scripts but there are no dependent objects. Could you please let me know how to trouble shoot this problem again ???
thanks

[sanju_dba]

hi,

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.

Thanx
sanjay

[marist89]

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.