API to make invalid objects to valid in any instance

I would like to share you one standard API of making invalid objects valid in any instance.  This API will check the inter-dependencies between the objects and make them valid sequentially.  The below code needs to be run in apps schema which makes all the objects valid.  This info. I got from DBA who made 3600+ objects valid within half an hour.

BEGIN
exec sys.utl_recomp.recomp_parallel(20);
END;

No comments:

Post a Comment