Question: How do I switch
between Oracle databases in the same server? I just need to get into
SQL*Plus.
Answer:
If you are on the Oracle server you can execute the "oraenv" script to re-set
your ORACLE_SID and ORACLE_HOME to point to the new database. You can also
use
Linux command line alias settings for switching
between Oracle databases.
You
cal also use the at-sign notation to connect to SQL*Plus using TNS, like this:
sqlplus
fred/flintstone@mydbname
From within SQL*Plus, you can use the
connect command:
connect
fred/flintstone@mydbname
Finally, within SQL*plus you can
reference remote tables via a database link:
select * from cust@myremotedb;
