Re: Invalid objects

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 20 Oct 1999 20:18:09 +0800
Message-ID: <380DB301.5E7D@yahoo.com>

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

INVALID is generally due to dependency tracking by Oracle..

eg you have a view which is

select col1, col2
from table1

you then drop and recreate the table

The view may (or may not) still work - Oracle sets it to INVALID indicating that you should check that it still makes sense

alter view XXX compile;

will try to "recreate" the view and ensure that its definition is still sane...

Have a look at USER_DEPENDENCIES

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Oct 20 1999 - 07:18:09 CDT