Re: Running SQLs betweem RAC Instance

From: ibodogan <idogan_tech_at_yahoo.com>
Date: Thu, 3 Jan 2008 11:38:58 -0800 (PST)
Message-ID: <3d5d0a22-113a-4624-bad2-f07a12027220@s19g2000prg.googlegroups.com>


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

Original text of this message