If you want to avoid putting the connect string every time on your local client you can do the following
-- in unix
export TWO_TASK=HOMEDEV
-- in windows: set LOCAL key to mydb value in the registry or:
SET LOCAL=HOMEDEV -- your db connect string
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 25 09:26:19 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL@ HOMEDEV> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
-- in unix
export TWO_TASK=HOMEDEV
-- in windows: set LOCAL key to mydb value in the registry or:
SET LOCAL=HOMEDEV -- your db connect string
C:\Documents and Settings\inam>set LOCAL=HOMEDEV
C:\Documents and Settings\inam>sqlplus scott/tigerSQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 25 09:26:19 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL@ HOMEDEV> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
No comments:
Post a Comment