Re: how to redirect a TNS-request?

Patrick,

Change your tnsnames.ora entry at home.
There should be an entry in that file like: ora92 = ...
change it to:
ora9i = ...

Then you can keep all references in the code as "ora9i".

Shoen Tag noch!

"Patrick Zesar" <jonnypichler_at_gmx.net> wrote in message news:<3eca8217$0$17652$91cee783_at_newsreader02.highway.telekom.at>...
> i have the following situation:
> i'm working on a project in school, where i access an oracle-server whichs
> TNS-Name is 'ora9i'.
>
> unfortunately, i named my local oracle at home 'ora92'. So i have to change
> the TNS-Name in the code, everytime i change my working-environment (from
> school to home and back). i know it's not good code, when the connection
> parameters are included and all this stuff, but:
>
> is there a simple way to redirect all TNS-requests which go to 'ora9i' to my
> 'ora92'??
> probably by altering tnsnames.ora or something like that?
>
> any suggestions highly apprecciated, thx beforehand
>
> patrick
Received on Wed May 21 2003 - 04:31:25 CDT