Re: Running SQLs betweem RAC Instance
Date: Thu, 3 Jan 2008 11:38:58 -0800 (PST)
On Jan 3, 1:23 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> On Jan 2, 3:44 pm, ibodogan <idogan_t..._at_yahoo.com> wrote:
> > Is there a way to run a SQL in a RAC instance #1 from instance # 2 ?
> > thanks,
> > i.d.
> Yes if you want to setup via a job/schedule ... you can control which
> instance it is executed on.
> Google around for something like "dbms_job run on instance RAC" or
> similar. I think orafaq.com has some examples as well as oaktable ...
Thanks hpuxrac this was closest for what I asked but unfortunatelly I need to run this manually and as you see part of the code is running on instance # X while other part is running on another instance of RAC. i.d. Received on Thu Jan 03 2008 - 13:38:58 CST