Invalid objects

[malru]

Hi,

Can anyone explain me,What are the possible reasons so that the database object becomes invalid(STATUS -Invalid while checking in DBA_OBJECTS)?

Thanks,
Gajini

[TimHall]

Hi.

Often, this is caused by DDL operations on objects that your invalid objects were dependent on. For instance, if a table is modified, packages and procedures referring to that table are marked as invalid.

There are a number of ways to ercompile invalid objects:

http://www.oracle-base.com/articles/...emaObjects.php

Cheers

Tim...