Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Easy question, specify default database

Re: Easy question, specify default database

From: <cmcnally_at_my-dejanews.com>
Date: Wed, 14 Apr 1999 15:36:01 GMT
Message-ID: <7f2cl1$cs2$1@nnrp1.dejanews.com>


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 - 10:36:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US