Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Invalid objects
>
> If I perform the query
>
> select owner||'.'||object_name, object_type from dba_objects
> where status = 'INVALID';
>
> I find a number of procedures, packages, package bodies and
views are
> listed.
>
> What would cause an object to become invalid and what are the
implcations
> for the application?
>
> Margaret
>
>
The most common reason for an object to become invalid is that
an object that was referenced has been modified or changed in
some way (a recompile, adding columns to tables, etc.).
altering an object in some way will by default invalidate all
objects that reference it in some way. don't worry though the
next time someone references or uses the invalid object it will
automatically try to recompile/revalidate itself. if the object
can successfully be recompiled/revalidated there will be no
impact to the user if it cannot be recompiled/revalidated then
an exception will be thrown.
andre azaroff
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=7024&cus_id=USENET&qtn_id=6280
Received on Wed Nov 03 1999 - 12:54:27 CST