Re: Easy question, specify default database

You should create string parameter called "local" in your win95/NT registry in oracle home.

Dmitry

cmcnally_at_my-dejanews.com wrote:
>
> I should have mentioned, I am using SQL Plus on a windows 95 machine.
>
> I don't know about this TWO_TASK env variable on 95.
>
> Chris
>
> In article <37137CCD.D21D77F8_at_KirchGruppe.de>,
> mh_at_goofy wrote:
> > Under Unix, set the environment variable TWO_TASK to the connect string. E. g.
> >
> > TWO_TASK=abc_def (where the listener listens to)
> > export TWO_TASK
> >
> > sqlplus bla/fasel
> >
> > will then connect to bla/fasel_at_abc_def
> >
> > Worked in Sun Solaris 2.5.1, Oracle 7.3.4.
>
> >
> > Martin
> >
> > cmcnally_at_my-dejanews.com schrieb:
> > >
> > > Hi,
> > >
> > > I'm trying to use the connect command in SQL plus, as in
> > >
> > > connect usernamne/password
> > >
> > > I don't want to use
> > >
> > > connect username/password_at_tns:oname
> > >
> > > since I want this to be generic. The oracle documentation says that I can
> > > specify a default database to connect to, but I cannot find how or where to
> > > do this. supposedly If I do this I can connect using SQL plus by supplying
> a
> > > valid username and password without the connect string.
> > >
> > > Anyone know how?
> > >
> > > Thanks in advance
> > > Chris
> > >
> > > -----------== Posted via Deja News, The Discussion Network ==----------
> > > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Apr 14 1999 - 12:03:06 CDT