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