RE: two_task parameter

Arslan,  

Two_task basically enables you to set up an identifier for a remote database that you may want to connect to.  

Usually you define the local database by setting the values of ORACLE_HOME and ORACLE_SID, setting TWO_TASK = <tnsconnect string> allows you to identify the remote database. When connecting instead of typing the command below to connect to a local database  

$ sqlplus user/pass
 

you can issue the setenv command to make the remote database your "local" one if you follow that.  

$ setenv TWO_TASK remote_db
$ sqlplus newuser/newpass
 

because you have set the TWO_TASK variable, it overrides the ORACLE_HOME and ORACLE_SID settings and when you login with newuser/newpass, the remote database is used as the local one.  

Hope this helps,
Regards
Kev Thomas
Calanais Ltd.

-----Original Message-----
Sent: 26 July 2001 09:01
To: Multiple recipients of list ORACLE-L

    what is the function of two_task parameter. i have searched metalink and documantion cd but i could nor find any note or document.

   please could you give information ?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thomas, Kevin
  INET: Kevin.Thomas_at_calanais.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).