Re: Invalid objects

From: Gert De Neve <Gert.DeNeve_at_advalvas.be>
Date: Thu, 21 Oct 1999 20:37:09 +0200
Message-ID: <7unnaj$qbk$2@news0.skynet.be>

The first time you try to use the invalid object, oracle tries to compile it. If successfull, you just lost a little bit of time. If not successfull, you will get an error message.

It's good policy not to have invalid objects in the db.

Hope this helps
Gert

Margaret Burwell <aj739_at_FreeNet.Carleton.CA> wrote in message news:7uki9v$r7n_at_freenet-news.carleton.ca...
>
> 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 Thu Oct 21 1999 - 13:37:09 CDT