Re: Altering a Session over a db link
From: TC <donotuse_at_donotuse.com>
Date: Mon, 07 Apr 2003 16:38:09 GMT
Message-ID: <RPhka.100574$OV.204278_at_rwcrnsc54>
Date: Mon, 07 Apr 2003 16:38:09 GMT
Message-ID: <RPhka.100574$OV.204278_at_rwcrnsc54>
No you cannot alter sessions over db_link
Try using hints in your query instead.
//tc
"Marc Foley" <marc_foley_at_hotmail.com> wrote in message
news:e468cf14.0304070718.1f817072_at_posting.google.com...
> Hi, I have a case where I need to use alter session to set a param but
> it needs to be done over a db link, can it be done and if so what is
> the syntax?
>
> More info:
> I have 2 databases A and B. The application always accesses database
> A which has a db link to B. I need to alter session in database B to
> set the optimizer_mode to rule to run a specific statement.
>
> Thanks for any help you can provide.
Received on Mon Apr 07 2003 - 18:38:09 CEST