Re: Invalid objects

An object can become invalid when underlying objects get dropped. For instance, if I have a view that accesses table1 and I drop table1, the view becomes invalid. This makes sense. How can the view be valid when the underlying table no longer exists? Similar arguments for procedures, pkgs, etc. Sybrand also illustrates good reasons why objects become invalid so I won't duplicate his efforts. If the underlying objects are all valid, recompile the invalid objects and they'll work fine. If the underlying objects are invalid (or don't exist), then you application won't be able to use the invalid object.

HTH,
Brian

Margaret Burwell wrote:
>
> 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
Received on Thu Oct 21 1999 - 07:57:44 CDT