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

Home -> Community -> Usenet -> c.d.o.server -> Invalid objects

Invalid objects

From: Margaret Burwell <aj739_at_FreeNet.Carleton.CA>
Date: 20 Oct 1999 14:06:55 GMT
Message-ID: <7uki9v$r7n@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 Wed Oct 20 1999 - 09:06:55 CDT

Original text of this message

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