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 -> Re: INVALID objects - which objects?

Re: INVALID objects - which objects?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 27 Oct 2004 19:55:37 -0700
Message-ID: <1098932078.336352@yasure>


Manfred Peter wrote:

> Hello Martijn,
>
> not all Oracle objects can be invalid. These are the objects:
> PACKAGES
> PACKAGE BODIES
> PROCEDURES
> FUNCTIONS
> TRIGGERS
> VIEWS
> TYPES
> TYPE BODIES
>
> Hope this list is complete
>
> Best regards
> Manfred Peter
> Alligator Company Software GmbH
> http://www.alligatorsql.com
>
> Martijn Tonies wrote:
>

>> Hello,
>>
>> Can ANY object in Oracle have the status "invalid"?
>>
>> Or is this only applicable to source code objects (Stored
>> Procedures, Packages, Types etc...)

You forgot indexes. Something I posted days ago.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Wed Oct 27 2004 - 21:55:37 CDT

Original text of this message

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