Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus question
In article <Xns933CBA06CA2D1SunnySD_at_68.6.19.6>, "Ana says...
>
>"Jerry" <JerryB_at_hotmail.com> wrote in
>news:oSQba.454791$Yo4.20100646_at_news1.calgary.shaw.ca:
>
>> I already log in to server via sqlplus, then switched to another user,
>> failed due to wrong password. at this time, I was not connected to
>> Oracle server. But, I think it makes sense if I stay connected as old
>> user. Is it possible?
>>
>>
>>
>
>no
Well, that was short and sweet! :)
It was also correct however. When you connect as a new user, the first step Oracle takes has to be to disconnect your previous connection. Once it's gone, it's gone I'm afraid.
HTH. Additions and corrections welcome.
Pete
SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Thu Mar 13 2003 - 11:15:00 CST