Re: How do I start SQL*Plus under a different database?

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Mon, 13 Jan 2003 21:00:38 GMT
Message-ID: <WNFU9.80$1D1.5067921@newssvr15.news.prodigy.com>

Peter Chatterton wrote:
> I'm running 9iAS on win2K sp3.
>
> There are 2 databases, OEMREP and AGENCYDB; the former being the
> default/primary/whatever.
>
> My Question is: How can I start SQL*Plus under the other db?
>
> Thanks,
> Peter.
>

From DOS window:

set oracle_sid=agencydb
sqlplus...

For GUI (sqlplusw.exe):

Change Oracle Home (it's off the Start menu ... but I've modified mine to the point where I don't remember what it is by default). Look under one of the zillion or so entries that Oracle puts under Start / Programs for something like Home Selector. Change it, then start your GUI sqlplus. Received on Mon Jan 13 2003 - 15:00:38 CST