ah but you can do something similar, at least according to Joe -- he
found it on a thread on MetaLink.
You put a tnsnames.ora file in your local directory (I would suppose
without setting TNS_ADMIN) and then it will use the local one
interesting, veddy interesting
- Jared.Still_at_radisys.com wrote:
>
> Not only is it not in the flaming manuals, I don't think you
> can even do that on Windoze.
>
> Sure, you can set the TNS_ADMIN var in
> ControlPanel->System->EnvVars, but that is rather broad
> in scope and does not offer the granularity available on unix.
>
> Jared
>
>
>
>
>
> Rachel
>
> Carmichael To: Multiple recipients
> of list ORACLE-L <ORACLE-L_at_fatcity.com>
> <wisernet100_at_Y cc:
>
> AHOO.COM> Subject: RE: stupid
> oracle on windoze question
> Sent by:
>
> root_at_fatcity.c
>
> om
>
>
>
>
>
> 01/02/02 07:50
>
> AM
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
> well the thing is, he wasn't looking for TNS_ADMIN since that just
> re-sets the directory Oracle looks at but wanted something that
> worked
> more like how login.sql works -- where if you have the file in your
> local working directory, it is used and overrides any other file.
>
> In Unix, if you have a .tnsnames.ora file (please note the initial
> ".")
> in your own personal $HOME directory) it will override the values in
> the $ORACLE_HOME/network/admin/tnsnames.ora or the
> $TNS_ADMIN/tnsnames.ora file
>
> THAT is what Joe wanted for Windows. It ain't in the flaming
> manuals.
>
>
> --- Kimberly Smith <ksmith2_at_myfirstlink.net> wrote:
> > Damn, why don't people use the manuals. TNS_ADMIN. Actually, you
> > can set
> > the puppy on Unix as well.
> > -----Original Message-----
> > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of JOE
> > TESTA
> > Sent: Wednesday, January 02, 2002 6:15 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: stupid oracle on windoze question
> >
> >
> > ok in the unix world, we have .tnsnames.ora file which overrides
> a
> > $HOME/network/admin/tnsnames.ora file.
> >
> > Is there such a thing in the windoze world. a registry entry
> > maybe?
> >
> > thanks, joe
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Jared.Still_at_radisys.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Jan 02 2002 - 12:16:36 CST
