Re: Invalidated Objects ...

Rajesh Bhave wrote:
> 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.

No. You don't even have to recompile stored procedures. I've used this when I'm upset with a user (not on purpose mind you). We've had to drop and recreate objects and just left he invalid ones around (development system). When the first user calls complaining about something failing I always make a big deal about it and make them recreate the problem. They can't because all the invalid objects have been make valid and the 2nd time they execute the problem is gone.

Or I run:

 execute dbms_utility.compile_schema("schema name");

Just to get everything recompiled.

later,
ed Received on Thu Dec 03 1998 - 16:15:28 CST