Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Invalid objects

Re: Invalid objects

From: QuestionExchange <USENET_at_questionexchange.com>
Date: 3 Nov 1999 18:54:27 GMT
Message-ID: <2352qx@questionexchange.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US