Changing connection in SQL*Plus [message #80218] |
Mon, 26 August 2002 03:29 |
Andoni OConchubhair
Messages: 2 Registered: August 2002
|
Junior Member |
|
|
Hello,
Two questions on the same theme:
<ol>[*]When I'm in SQL*Plus connected to one db and type
SQL>connect system/manager@mydatabase
does this change my current connection or just create a new 2nd connection? I.e. do I have to be careful to close out of both connections now?
[*]Is there a command I can type in SQL*Plus to check which of my databases/tnsnames.ora entries, I'm currently connected to?
</ol>
Thanks in Advance,
|
|
|
|