Dear memeber:
How do yo switch between databases when you have more than one database. I think there is some command like set Oracle_SID= bdname.
Is that correct. Can you use this in SQL*Plus enviornment. Thanks.
Printable View
Dear memeber:
How do yo switch between databases when you have more than one database. I think there is some command like set Oracle_SID= bdname.
Is that correct. Can you use this in SQL*Plus enviornment. Thanks.
When using NT, you can set the ORACLE_SID variable. It's also important to verify the PATH. Be sure the Oracle version you want to use comes first in the PATH.
WHen using unix, you can use '. oraenv' and select an SID available in the /etc/oratab file. This will set the ORACLE_SID and other necessary variables. ( eg. PATH )
HTH
Gert
In Win NT ,2000 Command prompt
c:\> set oracle_sid=sid (without spaces between equal symbol)
will allow you to switch between databases.
Thanks