Re: Running SQLs betweem RAC Instance
From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Thu, 3 Jan 2008 11:23:12 -0800 (PST)
Message-ID: <65d5f0a8-c568-48d7-84f2-47f4a8f912bf@f3g2000hsg.googlegroups.com>
Date: Thu, 3 Jan 2008 11:23:12 -0800 (PST)
Message-ID: <65d5f0a8-c568-48d7-84f2-47f4a8f912bf@f3g2000hsg.googlegroups.com>
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 ... Received on Thu Jan 03 2008 - 13:23:12 CST