Re: Easy question, specify default database

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
Received on Tue Apr 13 1999 - 12:20:13 CDT