Re: Invalidated Objects ...

Hi,

You can drop and recreate table. Compile invalid objects after this:

alter <object> <object_name> compile;

or

alter <object> <object_name> compile body;

Last one is applicable to package and type bodies. You do not need no create them from scripts.

Andrew Protasov

> Hi,
>
> I need to ask this question because I don't have access to Oracle.
> I know that when table is dropped, its dependent objects get
> invalidated. Consider that I have recreated the table again, then do I
> have to drop and create these dependent schema objects again ? Let me
> know.
>
> Rajesh Bhave
>
>
>
Received on Thu Nov 26 1998 - 09:00:00 CST