Thanks Karsten, you wouldn't believe what i've gone thru looking for this
answer! Peter.
"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message
news:WNFU9.80$1D1.5067921_at_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:44:45 CST
