RE: Recompile remote objs
From: Kenneth Naim <kennethnaim_at_gmail.com>
Date: Wed, 8 Sep 2010 20:16:19 -0400
Message-ID: <01ce01cb4fb4$3aa9df70$affd9e50$_at_com>
Date: Wed, 8 Sep 2010 20:16:19 -0400
Message-ID: <01ce01cb4fb4$3aa9df70$affd9e50$_at_com>
- If you have create any procedure privilege or alter any procedure/view etc, you could create a procedure that selected all invalid objects and recompiled them., this would work for objects except ones owned by sys.
- If you have sysdba dba access to the remote system then you could create a sys owned package that would do this for all schemas. If you wanted to get fancy you could use order the list of objects to be compiled based on dependencies similar to utlrp.
- Create a shell script on the remote side that run utlrp, and whenever you want to run schedule it using the scheduler for immediate execution
Ken
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Jared Still
Sent: Wednesday, September 08, 2010 5:12 PM
To: joe_dba_at_hotmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Recompile remote objs
On Wed, Sep 8, 2010 at 12:58 PM, Joe Smith <joe_dba_at_hotmail.com> wrote:
If not, how would you go about recompiling remote invalid objects?
What problem are you trying to solve?
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 08 2010 - 19:16:19 CDT