Re: TWO task

--0-2044897763-961183930=:23326
Content-Type: text/plain; charset=us-ascii

TWO_TASK is a way to set a default connect string for subsequent net8 connections. For example the following are equivalent:

   sqlplus user/password_at_mydb

-and-

   TWO_TASK=mydb
export TWO_TASK
sqlplus user/password

Where do you set it? Depends on what you want to use it for. If you want all connections for your login session to go to a specific database, set int in your .profile script. If you're writing a shell script that repeatedly connects to the same remote database, you could set it in the top of the script and then not have to specify an @connect-string each time you run sqlplus.  

"Gopal, Umesh" wrote:

Can anyone please tell me the following : what is the significance of the TWO_TASK variable ?? where do I set it on a Sun Solaris machine and Oracle 8i?

Thanks
Umesh

-- 
Author: Gopal, Umesh
INET: ugopal_at_proxicom.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). 




---------------------------------
Do You Yahoo!?
Send instant messages with Yahoo! Messenger.
--0-2044897763-961183930=:23326
Content-Type: text/html; charset=us-ascii



<P>TWO_TASK is a way to set a default connect string for subsequent net8 connections. For example the following are equivalent:</P>

<OL>

<LI>sqlplus user/password_at_mydb<BR><BR>-and-<BR></LI>

<LI>TWO_TASK=mydb<BR>export TWO_TASK<BR>sqlplus user/password</LI></OL>

<P>Where do you set it? Depends on what you want to use it for. If you want all connections for your login session to go to a specific database, set int in your .profile script. If you're writing a shell script that repeatedly connects to the same remote database, you could set it in the top of the script and then not have to specify an @connect-string each time you run sqlplus.<BR></P>

<P>&nbsp;<BR><B><I>"Gopal, Umesh" <UGOPAL_at_PROXICOM.COM></I></B>wrote: <BR></P>

<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"><BR><BR><BR>Can anyone please tell me the following :<BR>what is the significance of the TWO_TASK variable ??<BR>where do I set it on a Sun Solaris machine and Oracle 8i?<BR><BR>Thanks<BR>Umesh<BR><BR>-- <BR>Author: Gopal, Umesh<BR>INET: ugopal_at_proxicom.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing). <BR></BLOCKQUOTE><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br>

Send instant messages with Yahoo! Messenger.