how to redirect a TNS-request?

From: Patrick Zesar <jonnypichler_at_gmx.net>
Date: Tue, 20 May 2003 21:30:14 +0200
Message-ID: <3eca8217$0$17652$91cee783@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 Tue May 20 2003 - 14:30:14 CDT