Re: Invalid objects

From: Van Messner <vmessner_at_netaxis.com>
Date: Wed, 20 Oct 1999 18:49:23 -0400
Message-ID: <fGrP3.22980$E_1.1251606@typ11.nn.bcandid.com>

It's also possible for objects to become invalid after a migration or an upgrade. You should always check the status of objects after you are done.

Van

Edorta <edortta_at_yahoo.es> wrote in message news:380DD7C9.5079E43C_at_yahoo.es...
> You can't use an object which is in an invalid state.
> An object A becomes invalid when it depends on another object B, and B
> changes. For example, if you compile a package which contains a function
used
> by a view, this view becomes invalid, etc.
>
> Margaret Burwell wrote:
>
> > If Iperform 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
>
Received on Wed Oct 20 1999 - 17:49:23 CDT