Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Saturday, December 25, 2010

Setting the Default Connect String

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


C:\Documents and Settings\inam>set LOCAL=HOMEDEV
C:\Documents and Settings\inam>sqlplus scott/tiger

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

No comments: