Re: running UTLRP.sql

From: Kurt Franke <>
Date: Fri, 14 Nov 2008 19:57:20 +0100
Message-Id: <>

or build a calling wrapper around the procedures of definer rights package SYS.UTL_RECOMP which is used behind the script utlrp.sql this wrapper may limit the recompilation to certain schemas depending on the caller


> What exactly is it you are trying to accomplish? If it is to re-
> validate objects after a change, there are other ways to go about it
> than using utlrp.sql . You could wrap DBMS_UTILITY.COMPILE_SCHEMA in
> a package that certain users/roles could call. You could also find,
> via web search, a myriad of scripts that do a similar things.

Received on Fri Nov 14 2008 - 12:57:20 CST

Original text of this message