Re: TWO_TASK environment variable

On 4/11/07, tom r <mailbin@xxxxxxxxxxx> 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

scott@dv1 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

scott@dv12 SQL>



--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Relevant Pages

  • Re: RMAN encountering LDAP error
    ... Disconnected from Oracle Database 10g Enterprise Edition Release ... sh-2.05b$ rman target / ... Recovery Manager: Release 10.1.0.3.0 - Production ...
    (comp.databases.oracle.server)
  • Re: Licensing rules for Data Guard
    ... am I right that that it is not available as an option for Standard ... and is available only in Enterprise Edition? ... If I read correctly, the log shipping technique, which is well documented on multiple sites, involves shipping archived, rather than active, re-do logs and therefore is certain to be minutes, rather than the max 5 seconds, out-of-phase that we need. ... dependent upon your ability to negotiate with your Oracle sales rep. ...
    (comp.databases.oracle.server)
  • Re: Which version of D2005 do I need?
    ... > it's name in next release MSSQL Express Edition), Interbase, and MySQL. ... > Oracle, Interbase, and others you'll need the Enterprise Edition. ... I haven't checked this out yet, because both Delphi 2005, and RemObjects SDK ... one would be able to get the RAD database connectivity for Oracle, ...
    (borland.public.delphi.non-technical)
  • Re: TRIM and database inserts/update
    ... Copyright 1982, 2005, Oracle. ... Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production ... SQL> create table t ( ...
    (comp.databases.oracle.server)
  • Having trouble of Creating OLE DB Connection on Windows 2003 64bit with SQL 64bit using BI Studio 20
    ... We have a new server installed with Windows 2003 64bit Enterprise edition plus SQL 64bit Enterprise edition. ... We need to use Business Intelligence Studio to create a SSIS project which will retrieve data from a Oracle database server. ... Installation went well. ...
    (microsoft.public.sqlserver.odbc)