Re: setting up to access remote Oracle

Thanks to you and all who replied! I'm glad it wasn't a figment of my imagination. :)

janine

On Nov 7, 2004, at 8:50 AM, Carel-Jan Engel wrote:

> set TWO_TASK in your environment to the correct connect-string alias.
> It
> is not a fall-back thing, it simply directs the connect to use the
> specified connect-string.
> Best regards,
>
> Carel-Jan Engel
>
> ===
> If you think education is expensive, try ignorance. (Derek Bok)
> ===
>
> On Sun, 2004-11-07 at 05:38, Janine Sisk wrote:
>
>> If I type "sqlplus user_at_SID" it works, but I'd like to be
>> able to drop the @SID part. I have a vague, quite possibly incorrect
>> memory that if you have ORACLE_SID set (which I do) SQL*Net will use
>> it
>> when the local connect fails, but I haven't been able to get it to
>> work.
>>
>> Is it possible to do this, and if so, can anyone provide an example?
>>
>> Thanks,
>>
>> janine
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l