-
Invalid objects
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
-
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|