On 4/11/07, tom r <[EMAIL PROTECTED]> wrote:
>
> i believe that sql*plus does not use
> TWO_TASK.
>
>
Sqlplus does use TWO_TASK.
10:31-ordevdb01:dv11:jkstill-18 > oenv
ORACLE_SID : dv1
TWO_TASK :
ORACLE_HOME : /u01/app/oracle/product/10.2.0/10gr2dev
IAS_ORACLE_HOME :
ORACLE_BASE : /u01/app/oracle
NLS_LANG :
ORA_NLS33 :
LD_ASSUME_KERNEL :
LD_LIBRARY_PATH :
/usr/dt/lib:/usr/lib:/usr/lib/X11:/u01/app/oracle/product/10.2.0/10gr2dev/lib:/u01/app/oracle/product/10.2.0/10gr2dev/ctx/lib
[ /home/jkstill ]
> sqlplus scott/tiger
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Sep 11 10:31:42 2007
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Oracle Label Security and Data Mining options
------------------------------
DV1
[EMAIL PROTECTED] SQL>
Disconnected from Oracle Database 10g Enterprise Edition Release
10.2.0.3.0- Production
With the Partitioning, Oracle Label Security and Data Mining options
> export TWO_TASK=dv2
[ /home/jkstill ]
10:31-ordevdb01:dv11:jkstill-18 > sqlplus scott/tiger
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning option
JServer Release 9.2.0.8.0 - Production
Data Base
------------------------------
DV2
[EMAIL PROTECTED] SQL>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
