Re: Running SQLs betweem RAC Instance
From: Steve Howard <stevedhoward_at_gmail.com>
Date: Wed, 2 Jan 2008 17:58:14 -0800 (PST)
Message-ID: <aa24bd1a-9071-4445-8361-a0d1e44c968a@i7g2000prf.googlegroups.com>
Date: Wed, 2 Jan 2008 17:58:14 -0800 (PST)
Message-ID: <aa24bd1a-9071-4445-8361-a0d1e44c968a@i7g2000prf.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.
Out of curiosity, is there any reason you want/need to do this? If you do have legitimate need, you can always just create a database link in the RAC database that point to a TNS alias for only instance #1 of that database. Whenever you use that link, you will connect only to instance #1.
HTH, Steve Received on Wed Jan 02 2008 - 19:58:14 CST