On Thu, Sep 9, 2010 at 11:35 AM, Joe Smith <joe_dba@xxxxxxxxxxx> wrote: > Yes,there are db links between the servers. > > There you go - create a remote stored procedure that recompiles, execute it via db link. Jared