Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: INVALID objects - which objects?
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