Hi all,
I am seeing a quite strange issue here.
The schema owner '****' is connected to the database. Please disconnect and try again.
I tried to disconnect the user with the following command
select sid,serial# from v$session where username = '****';
alter system kill session '131,6' immediate;
I then see the the commands got successfully executed, and for a little while, there is not such user connecting to my database as I can do another select and no row is selected. But within some short amount of time, I see a new connection. In this case, how can I terminate the connection once and for all? Please help me and many thanks!