database connection [message #71374] |
Thu, 24 October 2002 06:03 |
srikanth
Messages: 40 Registered: July 2001
|
Member |
|
|
A trivial question
I have 3 databases,now how do i basically connect to a database or in other words how do i change my database??
Thanx in advance
Srikanth
|
|
|
Re: database connection [message #71375 is a reply to message #71374] |
Thu, 24 October 2002 06:14 |
gp
Messages: 46 Registered: September 2002
|
Member |
|
|
what exactly do u mean by change my db
if u can just connect by giving sqlplus username@<SID>
or u can give export ORACLE_SID=<SID> command on unix
or if u want to connect to another database from one u can create dblink...
|
|
|
|
Re: database connection [message #71380 is a reply to message #71374] |
Thu, 24 October 2002 12:30 |
sai sreenivas jeedigunta
Messages: 370 Registered: November 2001
|
Senior Member |
|
|
Hi,
if u mean, u want to set a Default database out of the 3 databases, then Try for setting the value for ORACLE_SID in Regedit -> HKey_local_machine-> ORACLE -> etc for Windows box , Set in ORATAB for Unix based machine..
Byee
sai
|
|
|